Filter stage: Options

Use the Options section on the Stage tab to specify how the Filter stage operates.

Output rows only once

Set this to true to specify that rows are only output down the link of the first Where clause they satisfy. Set to false to have rows output down the links of all Where clauses that they satisfy.

Output rejects

Set this to true to output rows that satisfy no Where clauses down the reject link (remember to specify which link is the reject link on the parallel job canvas).

Nulls value

Specify whether null values are treated as greater than or less than other values.