Database Reference
In-Depth Information
The description of the properties shown in the preceding screenshot is as follows:
Property
Description
If you check this option, the data is loaded into the target based on the relationship between the
primary key and the foreign key wherever possible.
Constraint based load ordering
This property is related to the lookup transformation functionality. By default, lookup transformation
performs a row-by-row operation. If you check this option, Informatica overrides mapping level look-
up settings.
Cache LOOKUP() function
