Database Reference
In-Depth Information
Consider that the
EMPLOYEES
table data depends on the
DEPARTEMNTS
data because of
the primary key and foreign key constraints. So, to satisfy the referential integrity, the
DEPARTMENTS
table should be loaded first. The target load order is useful when you
wish to handle referential integrity while inserting, deleting, or updating data in tables that
have the primary key and foreign key relationships.
To set the target load plan in a mapping, perform the following process:
1. In the designer, navigate to
Tools
|
Mapping Designer
|
Mapping
|
Target Load
Plan
, as shown in the following screenshot:
2. New window will pop up, as shown in the following screenshot:
