Mapping RDMS Classifiers

While creating a transformation, you can map the source classifier and the target classifier in the ClassifierMap Designer.

  1. On the Schema View, expand the Application Group.

    The RDMS database schemas appear.

  2. Expand the required RDMS database schema to view the RDMS tables.

  3. You can choose to transform all the data from the RDMS table or only the selected data from an RDMS table version.

    • To transform all the data from an RDMS table

      1. On the Schema View, select a source classifier from the transformation source and drag it into the ClassifierMap Designer. Similarly, select and drag a target classifier from the transformation target into the ClassifierMap Designer.

      2. Click inside the box adjacent to the source classifier, and draw an arrow to connect to the target classifier.

    • To transform the selected data from an RDMS table version

      1. Select and right-click an RDMS table.

      2. Click Show Versions.

      3. On the Schema View, select an RDMS table version from the transformation source and drag it into the ClassifierMap Designer. Similarly, select and drag a target classifier from the transformation target to define a mapping.

  4. Click inside the box adjacent to the RDMS table version, and draw an arrow to connect to the target table.

    For more information about the color coding of the connection arrows, refer to Interpreting the Color of the Connection Arrows.

  5. On the Transformation menu, click Save.

    Alternatively, click the Save icon ().

RDMS Table Versions in Schema View

You can load RDMS schemas into the DDW Repository. The Application Group to which the database belongs is loaded on the schema view. Expand the Application Group to see the RDMS schemas, where each schema may have multiple tables. Expand the required RDMS schema to view tables. When you expand a table item, the columns and the keys (Primary Keys, Foreign Keys, and Unique Indexes) are displayed by default. Each RDMS table can have multiple table versions. Table versions are not visible by default. If you want to use the versions, you must use the “Show/Hide versions” functionality. The Properties pane dynamically displays the properties of the selected item.

Using the table versions, you can choose to

  • Map an entire table while defining a transformation so that the data of all the versions are transformed.

  • Map only specific versions of a table so that the data of only the selected table versions is transformed.

To see the versions

  1. Select and right-click an RDMS table.

  2. Click Show Versions.

To hide the versions

  1. Select and right-click an RDMS table.

  2. Click Hide Versions.

Select and right-click the RDMS schema, and click Show All Versions to see the versions of all the tables; click Hide All Versions to hide the versions of all the tables.