The columns in the following table define the key(s) used to map the row(s) to delete.
| Column | Description |
|---|---|
| Table field | Specify the field name from the populated list of Target table columns for which you want to compare. |
| Comparator | Specify the comparator you want to use. Note that case-sensitive
comparisons are possible, depending on your connected database and Target
table. You can select one of the following
comparators:
|
| Stream field 1 | Specify the name of the field from the incoming stream that contains the row you want to use for comparison against the Table field value. |
| Stream field 2 | Specify the name of the field from the incoming stream that contains the row you want to use for the BETWEEN comparison against the Stream field 1. |
| Get fields | Select this button to populate Stream field 1 and Stream field 2 from previous steps in your transformation. |
For example, if the look up value of QUANTITYORDERED is less than or equal to the min_quantityordered, and PRODUCTLINE values map equally, then that QUANTITYORDERED row is deleted from the STG_SALES_DATA table.