RE: How do we load multiple targets present in dataflow in a sequential manner?
When there are more than one target present in a dataflow, and we need to load these targets in a sequential manner one after the another. We choose the “Target Order” present in dataflow.
Dataflow à Load Order à Target Order.
We can choose the order based on the requirement which target to be loaded. In the below snapshot it is loading the TGT_Employee_us first and TGT_Employee_ind second.