To configure a DML command substitution at the transformation level
From the Transformation View, select the required transformation.
In the Properties pane on the right, under DML command substitution, a list of source and target commands are displayed.
In the left column, select the source command and in the right column, select the required target command from the drop-down list.
The following tables display the supported source commands for each data store type and the available target commands that can be mapped to it.
Table 6. DML Command Substitution at Transformation Level for Enterprise Database Server as Source
| Target Data Store Type | |||
| SQL Server Database | Oracle Database | ||
| Source commands | Available Target commands | Source commands | Available Target commands |
| Create | Insert Update Delete Merge <Ignore> <Default> | Create | Insert Update Delete Merge <Ignore> <Default> |
| Modify | Insert Update Delete Merge <Ignore> <Default> | Modify | Insert Update Delete Merge <Ignore> <Default> |
| Delete | Insert Update Merge <Ignore> <Default> | Delete | Insert Update Merge <Ignore> <Default> |
Table 7. DML Command Substitution at Transformation Level for RDMS as Source
| Target Data Store Type | |||
| SQL Server Database | Oracle Database | ||
| Source commands | Available Target commands | Source commands | Available Target commands |
| Insert | Insert Update Delete Merge <Ignore> <Default> | Insert | Insert Update Delete Merge <Ignore> <Default> |
| Update | Delete* <Ignore> <Default> | Update | Delete* <Ignore> <Default> |
| Delete | <Ignore> <Default> | Delete | <Ignore> <Default> |
*The target command Delete is available only when the target has a primary key, and a source primary key is mapped to this primary key.
Table 8. DML Command Substitution at Transformation Level for SQL Server as Source
| Target Data Store Type | |
| Enterprise Database Server | |
| Source commands | Available Target commands |
| Insert | Create Modify Delete Merge <Ignore> <Default> |
| Update | Create Modify Delete Merge <Ignore> <Default> |
| Delete | Create Modify Merge <Ignore> <Default> |