You can specify the flow run order when you want Data Integration to load the targets
in the mapping enabled for SQL ELT optimization in a particular order.
If your mapping contains multiple pipelines, you can define the flow run order to load the
targets from the pipelines in a particular order. To define the data flow run order
during SQL ELT optimization, see the Data Flow Run Order Informatica Knowledge
Base Article.