Delete

Description

The delete transform deletes rows of data from a database. This transform is similar to the update family of transforms in that it takes one or more key fields to determine the rows to delete.

delete

Options

Option Description

Transform name

Name of the transform. This name has to be unique in a single pipeline.

Connection

The database connection to which data is written

Target schema

The name of the Schema for the table to which data is written. This is important for data sources that allow for table names with periods in them.

Target table

Name of the table in which you want to do the insert or update.

Commit size

The number of rows to change (insert / update) before running a commit.

The keys(s) to look up the value(s)

Specify fields to delete the corresponding rows for