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.
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 |