Funnel stage: Properties section

Use the Properties section on the Stage tab to specify how the Funnel stage operates.

The Properties section allows you to specify properties which determine what the stage actually does.

The following table gives a quick reference list of the properties and their attributes. A more detailed description of each property follows.

Table 1. Properties
Category/Property Values Default Mandatory? Repeats? Dependent of
Options/Funnel Type Continuous Funnel/ Sequence/ Sort funnel Continuous Funnel Y N N/A
Sorting Keys/Key Input Column N/A Y (if Funnel Type = Sort Funnel) Y N/A
Sorting Keys/Sort Order Ascending/ Descending Ascending Y (if Funnel Type = Sort Funnel) N Key
Sorting Keys/Nulls position First/Last First Y (if Funnel Type = Sort Funnel) N Key
Sorting Keys/Case Sensitive True/False True N N Key
Sorting Keys/Sort as EBCDIC True/False False N N Key