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