You are here:

Cross Reference Source Mapping

In the Key Field(s) text box, do one of the following:
- Enter the name of the source field to use as a key
- Click the Browse button (). The Source Cross Reference Key Builder dialog box appears, where you can select a source field or create a multi-field source key.

If applicable, in the Field in Cross Reference Table drop-down list box, select the field in the table specified in the Cross reference table field to store the source key value.

Note: If you are using a SQL source with a SQL target, verify that the Key Cross Reference target is mapped to a unique field whose value comes from the source. Otherwise, the Key Cross Reference table may not be populated as expected.

Operation	Valid fields
Update Source result set Update Source shadow or base table	N/A The specified source key fields are already updated.
Insert into Other source table Insert into Target table	Select the field in the table to store the source key value.
Insert into Internal Database Table and Cross Reference table = KEYCROSSREFERENCE	Field defaults to SOURCEKEY and cannot be changed.
Insert into Internal Database Table and Cross Reference table = KEYCROSSREFERENCETWOWAY	Select either APP_A_KEY or APP_B_KEY

If the operation is Insert into Internal database, use the Name Field(s) text box to provide a human-readable, "friendly” name for the field that is stored in the cross reference table. To add a name to the Name field, you can either:
- Enter the name you want to use for this field in the cross reference table
- Click the Browse button. The Source Cross Reference Name Builder dialog box appears, where you can select a source field or create a multi-field source name.
  Entering a name in the Name Field(s) text box is optional. If you don’t specify a field name, no value is stored. The name of the field in the Scribe Internal Database is determined by the cross reference table you select. If you selected:
- KEYCROSSREFERENCE, the field name is SOURCENAME and cannot be changed.
- KEYCROSSREFERENCETWOWAY, the field name is either APP_A_NAME or APP_B_NAME, depending on the key field selected above.
If source name fields have been specified in Configure Source, those values will be used to the default Source Name Field(s) in Key Cross Reference.
Note: Name values in cross reference entries are only updated when the cross reference entry itself is updated. Keep in mind that the name stored with the entry may become out-of-date if it is changed in the application at a later time.
Define the target mapping.