Database Reference
In-Depth Information
To set the target load plan, just move the target load group using the arrow provided in the
window. To load the
DEPARTMENTS
table before the
EMPLOYEES
table, select
SQ_DEPARTMENTS
and click on the up arrow, as shown in the preceding screenshot.
This will make the
DEPARTMENTS
table load before the
EMPLOYEES
table is loaded,
and we can avoid failure.
When we use the target load plan, Informatica PowerCenter actually restricts the extrac-
tion of the data from the source qualifier. It waits for the first flow in the selected se-
quence to finish loading the data and then starts extracting the data from the second source
qualifier for its loading.
