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
- In the XML Data Configuration
tree, right-click Dimension
Mappings, click .
- Specify a name. The name cannot contain special
characters and
must be unique within an XML data configuration file.
- Optional: Type a description.
- 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.
- Specify the source and
target column names. These are the names
of the semantically similar element in the source table and the target
table.
- Click Add.
- 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.
- Click Next, specify the source and target
values, and click Add. Repeat the previous
step for
all other values that you want to map.
- Click Finish.