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.