An INSERT, UPDATE, or DELETE statement creates source and target objects in the mapping that are logical data objects.

Only one INSERT, UPDATE, or DELETE statement is valid. For example, a statement that contains an INSERT and a nested UPDATE statement is not valid.

When the INSERT, UPDATE, or DELETE SQL statement contains a correlated subquery, the Developer tool cannot generate a mapping.

An UPDATE or DELETE statement creates an Update Strategy transformation in a mapping. Because an Update Strategy transaction requires a primary key, the data target must contain a primary key. After mapping generation, verify the primary keys.

The Developer tool ignores any INSERT statement in an ORDER BY clause because relational databases do not follow ordering when inserting data.