While creating a new transformation, you can map a source classifier and a target classifier in the ClassifierMap Designer.
On the Schema View, expand the Enterprise Database Server schema.
The Enterprise Database Server data sets appear.
Select an Enterprise Database Server data set, and drag it into the ClassifierMap Designer.
On the Schema View, expand the target database.
The target database schemas appear.
Expand the required target database schema to view the target classifiers.
Select a target classifier, and drag it into the ClassifierMap Designer.
Notes:
You can drag multiple classifiers at a time into the ClassifierMap Designer. Press the Ctrl key, and select the required classifiers.
You can drag only the classifiers into the ClassifierMap Designer. Hovering the mouse over a table displays a hand icon, which indicates that the item can be dragged. The hand icon is not displayed when you hover the mouse over a feature that cannot be dragged.
Click inside the box adjacent to the source classifier, and draw an arrow to connect to the target classifier.
For more information about the color coding of the connection arrows, refer to Interpreting the Color of the Connection Arrows.
On the Transformation menu, click Save.
Alternatively, click the Save icon (
).Notes:
A Remapped data set is not supported while defining mappings in a transformation.
For an Oracle database as the transformation target, if two source data sets are mapped to the same target table and the target table has a primary key or a unique key, and if the DML substitution is Default, then the Oracle user must have Insert and Update privileges to run a BDT.
For more information about configuring DML command substitution, refer to Configuring DML Command Substitution.