Target Design

Set up a Simple Lookup Table

A simple lookup table contains one key.

Refer to Set up Lookup Tables for more information.

A lookup table that already exists can be edited or a lookup table can be added. The process is the same.

NOTE: The RuleXref action must be used with a lookup table that has multiple key fields. This will allow missing values in the Target table to be inserted into the Value Mapping table. The Xref action can only be used with a lookup table that has a single key field. If the Target Lookup table is a multiple key table, the Value Mapping process will concatenate Target values from the multiple key fields into a single field. To map fields on a multiple key lookup table, use the RuleXref action for the field to be mapped on the Field Mappings page. RuleXref concatenates Source values and is the recommended Migration Solution process to load the values correctly into the Value Mapping process.

NOTE: A description for the Lookup Table Value table can be added on the Target Lookup Table page's Vertical View in the Description field.

To add or edit a simple lookup table in Target Design:

  1. Select Configuration > Lookup Table Setup in the Navigation pane.

  2. Click Edit or Add

    .View the field descriptions for the Target Lookup Table page.

  3. Enter the name of the table that contains the values that are used in value mapping in the VALUE TABLE NAME field.

    NOTE: If editing a lookup table, this name is already provided.

  4. Select an option in the TYPE list box.
  5. Enter the key field in the lookup table in the VALUE TABLE COLUMN 1 field. 
  6. Enter the name of the table that stores the descriptions for the values in the value table in the DESCRIPTION TABLE NAME field.

    NOTE: This field displays in Map on the Vertical View of the Value Mapping (Config) page.

  7. Enter the name of the column that stores the descriptions for the values in the value table in the DESCRIPTION TABLE COLUMN field.
  8. Click Save.