Creating a dimension mapping table

You can create a dimension mapping table for correlating two resource groups. The resource groups can belong to two data configuration files.

About this task

To create a dimension mapping table:

Procedure

  1. In the XML Data Configuration tree, right-click Dimension Mappings, click New > Dimension Mapping Table.
  2. Specify a name. The name cannot contain special characters and must be unique within an XML data configuration file.
  3. Optional: Type a description.
  4. Specify the type of mapping:
    • To map specific values of result sets of the dimension tables, use the row-level mapping option.
    • To map elements of the dimension tables, use the column-level mapping option.
  5. Specify the source and target column names. These are the names of the semantically similar element in the source table and the target table.
  6. Click Add.
  7. Specify the source and target resource groups. If the target resource group belongs to a different data configuration file, use the Browse button to locate the data configuration file. Click OK. Repeat steps 1 through 7 for all other resource groups that you want to correlate in this dimension mapping table.
    Tip: If you are specifying column-level mappings, skip the next step.
  8. Click Next, specify the source and target values, and click Add. Repeat the previous step for all other values that you want to map.
  9. Click Finish.

Feedback