Mapping RDMS Features

  1. To map the RDMS features, double-click one of the classifiers in the ClassifierMap Designer.

    The FeatureMap Designer opens displaying the RDMS features in a tabular format.

    Notes:

    • If the entire RDMS table is mapped, all the associated features are displayed.

    • If a version of the RDMS table is mapped, the features associated with that particular table version are displayed.

  2. Click inside the box adjacent to the desired source feature and draw an arrow to connect to the target feature.

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

  3. On the Transformation menu, click Save.

    Alternatively, click the Save icon ().

To delete a connection between a source feature and a target feature, select the arrow, and press the Delete key.

Notes:

  • Right-click anywhere within the table in the FeatureMap Designer, and click Sort Feature Items. You can choose either Ascending, Descending, or Sort By Creation Order to sort the feature items. This enables you to locate a feature quickly when you have a large number of features in the FeatureMap Designer.

  • For real, float, and double column types, the precision value is not displayed in the FeatureMap Designer. It appears in the Properties pane and cannot be modified. The precision value is defined while designing the database.

  • You may have two source tables mapped to the same target table and both source tables have a primary key mapped to the primary key of the target table. While performing a CDT in this scenario, if there are two updated records (with the same value of the primary key), from each of the source tables, the second update will overwrite the first one.

GLB_DTime

GLB_DTIME is a unique generated field based on the OS 2200 double word time. Data Exchange can transform this GLB_DTime (9-bit) to a target of at least 12 bytes. The output is printable ASCII characters, but the characters may lie beyond the ASCII text (printable range). There are two possible solutions: