Using the Data Manipulation Language (DML) Command Substitution feature you can control and modify the transformation process with more flexibility. This feature lets you map a set of source commands to another set of commands at the target, which enables you to control the transformation at the command level. You can choose to ignore all changes made to the source data store as a result of a particular source command, or alter the command in the target data store.

The DML command substitution feature is available in the Properties pane. You can configure this feature at a transformation level or at a classifier level.

The following links provide more information about configuring the DML command substitution feature at the transformation and classifier levels: