RE: How to load the multiple pipelines present in a dataflow in sequential manner?
Dataflow which has multiple pipelines present in it which has multiple targets to be loaded. Then we choose the “Pipeline Order” option. Based on the Pipeline loader chosen the pipelines(source—target) present in dataflow executes.
In the below snapshot, based on the Pipeline Order chosen first the Hive Stage [HV_Employee_STG] table is loaded. Then Teradata Stage [TD_Employee_STG] table is loaded. Then the Teradata target table [TD_Employee] is loaded.