Funnel stage: Stage tab (DataStage)
The Stage tab for the Funnel stage enables you to control aspects of the Funnel stage.
On the Stage tab, the Properties section lets you specify what the stage does. The Advanced section allows you to specify how the stage executes. The Link Ordering section allows you to specify which order the input links are processed in.
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 |
Funnel type
Specifies the type of Funnel operation. Choose from:
- Continuous Funnel
- Sequence
- Sort Funnel
The default is Continuous Funnel.
Key
This property is only required for Sort Funnel operations. Specify the key column that the sort will be carried out on. The first column you specify is the primary key, you can add multiple secondary keys by repeating the key property. You can use the Column Selection dialog box to select several keys at once if required.
Key has the following dependent properties:
- Sort Order
Choose Ascending or Descending. The default is Ascending.
- Case Sensitive
Use this to specify whether each key is case sensitive or not, this is set to True by default, that is, the values "CASE" and "case" would not be judged equivalent.
- Sort as EBCDIC
To sort as in the EBCDIC character set, choose True.
- Nulls position
By default columns containing null values appear first in the funneled data set. To override this default so that columns containing null values appear last in the funneled data set, select Last.
Advanced
This section allows you to specify the following:
- Execution Mode. The stage can execute in parallel mode or sequential mode. In parallel mode the input data is processed by the available nodes as specified in the Configuration file, and by any node constraints specified on the Advanced section. In Sequential mode the entire data set is processed by the conductor node.
- Combinability mode. This is Auto by default, which allows IBM® DataStage® to combine the operators that underlie parallel stages so that they run in the same process if it is sensible for this type of stage.
- Preserve partitioning. This is Set by default. You can explicitly select Set or Clear. Select Set to request the next stage should attempt to maintain the partitioning.