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
1.
Go to
mappings - Target Load Plan
Adjust
the target group load order as per your requirements using Up, Down arrows
4. Click on OK and you
are done!
No comments:
Post a Comment