You are here:

Cross Reference Operations

Use the Operations section of the Cross Reference Keys dialog box to determine if you want to create a cross-reference key and if so, where you want to store the key.

To select the operation

Select one of the following operations:

Operation	Target Step = Insert	Target Step = Delete
Don't output key cross reference information	Disables cross reference keys	Disables cross reference keys
Update Source result set	The source row is updated with the target value.	The cross reference field in the source row that stores the target value is set to null.
Update Source shadow or base table	The source cross reference table is updated with the target value.	The cross reference field in the source table that stores the target value is set to null.
Insert into Other source table	A record containing the values specified in the source and target mapping sections is inserted into the source cross reference table.	The corresponding record in the cross reference table is deleted.
Insert into Target table	A record containing the values specified in the source and target mapping sections is inserted into the target cross reference table.	The corresponding record in the cross reference table is deleted.
Insert into Internal database table	A record containing the values specified in the source and target mapping sections is inserted into a cross-reference table in the Scribe Internal database.	The corresponding record in the cross reference table is deleted.

If you select an operation that requires a cross reference table, the Cross reference table drop-down list is enabled. Only valid tables display in the drop-down list. Select the table that you want to hold the cross reference entries.
If you selected Insert into Internal database table, choose a table in the Scribe Internal database. You can choose either:
- KEYCROSSREFERENCE — (default) Use for "one-way” synchronizations, where you would only ever need to lookup the target key given the source key. Note that KEYCROSSREFERENCE is only indexed on the SOURCEKEY column.
- KEYCROSSREFERENCETWOWAY — Use for "two-way” synchronizations, where you may need to lookup either key given the other one. KEYCROSSREFERENCETWOWAY is indexed on the APP_A_KEY and APP_B_KEY columns, for efficient lookups in both directions.
The Label field is only enabled when you select Insert into Internal database table with the KEYCROSSREFERENCE or KEYCROSSREFERENCETWOWAY table. Provide a label that uniquely identifies this cross reference so you can use the same Cross Reference table to store cross reference data between many different data objects.
For example, if you have one DTS that synchronizes customers and another that synchronizes contacts, you might choose to label these tables CUSTOMER and CONTACT. Then all cross references can be stored in the KEYCROSSREFERENCE or KEYCROSSREFERENCETWOWAY table.
Define the Source Mapping.