DataDelete mapping

Use the DataDelete node to make DataDelete mappings, which delete existing database fields. You cannot use this node to insert or update records in a database; to perform these actions, use either a DataInsert node or a DataUpdate node respectively.

In a default generated DataDelete mapping, each row is deleted on the condition where the selected column is equal to the value of the repeatable element instance. The number of rows deleted depends on the number of instances:

One-to-one mappings are also allowed; in this case, the target column takes the value of the mapped input element. These insert statements can also be combined to produce a single insert that inserts several columns into the same row, as each insert statement creates a new row.

There are two ways to carry out this operation:

Edit the final WHERE clause of the combined mapping. Each pre-combination mapping already has a WHERE clause.

Related concepts
DataInsert mapping
DataUpdate mapping
Warehouse mapping
Related tasks
Creating a mapping file
Developing mappings
Related reference
DataDelete node
Mappings