[How To] Set Target Load Order in Informatica

When we have multiple interdependent data streams (pipelines) in our mapping, we can configure the Load Order of the Targets. This is often done to maintain referential integrity, maintaining consistent data or in a case where the target of first pipeline is source of the second pipeline in the same mapping.

In our example, we have two pipelines, one each for Student and Employee. Target Load Plan can be set at the mapping level in Designer as follows

1. Open Mapping

2. Go to mappings - Target Load Plan

3. Adjust the target group load order as per your requirements using Up, Down arrows.

4. Click on OK and you are done!

The target load plan shows Source Qualifiers and respective Targets.