You are here:

Defining Cross Reference Keys

Use the Cross Reference Keys dialog box to manage cross-reference keys between sources and targets.

Note:

The Update/Insert and Insert/Update steps do not support cross reference keys. Although the insert occurs correctly with these steps, the update does not check the cross-reference table.

If you are currently seeing this issue with the update operation and want to modify your DTS:

Replace each of the following steps in your DTS:
- Insert/Update — Replace with three separate operations: Seek, Insert, and Update.
- Update/Insert — Replace with three separate operations: Seek, Update, and Insert.
Run your DTS.
If the update is still not checking the cross-reference table, restart your Workbench.

To define a cross reference key

Select the Target Connection. If your DTS has multiple target connections, select the target connection from the drop-down list that you want to use for mapping and, optionally, for storing the cross reference key.
Select the cross-reference operation.
Map the source key fields.
Note: If Insight can determine a source key, or if it is specified by an adapter or in Configure Source, that value is used for the Source Mapping.
Map the target key fields.
Optionally, select a cross-reference lookup variable.
Note:
This feature requires special handling when working with bulk operations. See Using Bulk Operations for more information.