You can use a DataDelete or a Mapping node to delete data from a
database, based on information from an input message, another database or
both.
You cannot create mappings to delete data
from a database by dragging from the source to the target. Instead, you select
rows to delete based on the content of the source. You can use an expression
to match the content of the source to the target field, for example, use the
following instructions to delete all rows in the database that match the content
of a field from the input message:
You can use conditional mappings such as If statements to create
more complex mappings that define which data to delete from a database. You
can also use conditional statements in a Mapping node to perform different
database operations depending on the content of the input message. For example,
you can add a Table Inserts target, a Table Updates target and a Table Deletes
target to a message map, and then use conditional statements to define which
of the operations to perform.