Learning Informatica PowerCenter 10.x - Second Edition

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, ...