The key(s) to look up the value(s) table

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15

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:
  • =
  • <>
  • <
  • <=
  • >
  • >=
  • LIKE
  • BETWEEN
  • IS NULL
  • IS NOT NULL
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.