0 / 0
Funnel stage: Stage tab (DataStage)

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

The Funnel stage has the following properties:
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

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.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more