Managing the constraints - the target load plan

While you work on multiple mappings in a complex scenario, the situation may demand that you put multiple data flows in a single mapping to justify the performance and the complexity. A sample mapping depicting the previous statement is shown in the following screenshot:

If you execute the previous mapping, the session may fail because of the primary key and foreign key violations on the database side. Since the Employee and Department tables are dependent on each other, when you run the mapping containing both flows, the process may fail if the data violates the dependency.

To avoid the issue, Informatica PowerCenter contains a utility called Target Load Plan. How do you plan to load the data into multiple targets in a mapping? We can load the data in a particular sequence in multiple targets in a mapping to avoid failure due to constraints.

Imagine that the EMPLOYEES table data depends on the DEPARTEMNTS data because of the primary key and foreign...