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.
Edit the final WHERE clause of the combined mapping. Each pre-combination mapping already has a WHERE clause.