0 / 0
Aggregator stage in DataStage: fast path

Aggregator stage: fast path

This section specifies the minimum steps to take to get an Aggregator stage functioning.

IBM DataStage has many defaults, which means that it can be very easy to include Aggregator stages in a job.

To use an aggregator stage:

  • Open the stage and expand Properties. In the Grouping Keys category:
    • Specify the key column that the data will be grouped on. You can repeat the key property to specify composite keys.

      Under the Aggregations category:

    • Choose an aggregation type. Calculation is the default, and allows you to summarize a column or columns. Count rows allows you to count the number of rows within each group. Re-calculation allows you to apply aggregate functions to a column that has already been summarized.

      Other properties depend on the aggregate type chosen:

    • If you have chosen the Calculation aggregation type, specify the column to be summarized in Column for Calculation. You can repeat this property to specify multiple columns. Choose one or more dependent properties to specify the type of aggregation to perform, and the name of the output column that will hold the result.
    • If you have chosen the Count Rows aggregation type, specify the output column that will hold the count.
    • If you have chosen the Re-calculation aggregation type, specify the column to be re-calculated. You can repeat this property to specify multiple columns. Choose one or more dependent properties to specify the type of aggregation to perform, and the name of the output column that will hold the result.
  • On the Output tab, select Edit in the Columns section. and in the Maps from input column, check that the mapping is as you expect (IBM DataStage maps data onto the output columns according to what you specify in the Properties section).
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