Associating Reference Tables with Mappings

Reference data sets the permissible values for other data fields. To standardize your data, you can associate a reference table with mappings. Ensure that you publish the required reference table before associating it with mappings.

To associate reference tables with Mappings, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click a map.

    3. The Mapping Specification grid appears.

  3. Click .
  4. Right-click the header menu.
  5. Select the Reference Table check box.

    6. The Reference Table column appears in the Mapping Specification grid.

  6. Drag the reference table from Reference Table Catalog and drop it on the required row under the Reference Table column.

    7. You can associate multiple source columns with the reference tables.

  7. Click .

    8. The reference table is associated with the mappings.