Defining Aggregator Output Data

When you output data from an Aggregator stage, the properties of the output link and the column definitions of the data are defined on the Outputs page in the Aggregator Stage dialog box.

The Outputs page has the following field and four tabs:

• Output name. The name of the output link. Since only one output link is allowed, the link name is read-only.
• General. Displayed by default. Select the aggregation type on this tab and type an optional description of the link. The Type field contains two options:
  • Group by sorts the input rows and then aggregates the data.
  • Control break aggregates the data without sorting the input rows. This is the default option.
• Aggregation. Contains a grid specifying the columns to group by and the aggregation functions for the data being output from the stage. See Aggregating Data for details about defining the data aggregation.
• Mapping. Specifies the mapping of input columns to output columns. See Mapping Data for details about defining mappings.
• Columns. Contains the column definitions for the data on the output link. This grid has the following columns:
  • Column name. The name of the column.
  • SQL type. The SQL data type. For details about the data types supported in mainframe jobs, see Data Type Definitions and Mappings.
  • Length. The data precision. This is the number of characters for Char data, the maximum number of characters for VarChar data, the total number of digits for numeric data types, and the number of digits in the microsecond portion of Timestamp data.
  • Scale. The data scale factor. This is the number of digits to the right of the decimal point for Decimal data, and zero for all other data types.
  • Nullable. Indicates whether the column can contain a null value.
  • Description. A text description of the column.

    You can Load columns from a table definition in the repository, or type column definitions manually and click Save As... to save them as a table definition, a CFD file, or a DCLGen file. Click Clear All to start over. For details about editing column definitions, see Editing Column Metadata.