Database Reference
In-Depth Information
Managing constraints - the target load
plan
While you work on multiple mappings in a complex scenario, situations might demand that
you put multiple data flows in a single mapping in order to justify the performance and the
complexity. A sample mapping depicting the preceding statement is shown in the following
screenshot:
If you execute the mapping, the session might fail because of the primary key and foreign
key violation. As the
Employee
and
Department
tables have dependencies on each
other, when you run the mapping containing both the flows, the process might fail if the
data violates the dependency.
To avoid the issue, Informatica PowerCenter contains a utility called the 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 in order to avoid failure due
to constraints.
