Developer Transformation Guide

Back Next

Aggregator Transformation Ports

An Aggregator transformation has multiple port types that you can use to configure groups and to aggregate expressions.

An Aggregator transformation Ports view has the following fields:

Name: Name of the port.
Type: The port data type.
Precision: Length of the field.
Scale: The number of positions to the right of the decimal for numeric data.
Input: Indicates that data is from an upstream transformation.
Output: Indicates that the port returns the value of an expression. The expression can include non-aggregate expressions and conditional clauses. You can create multiple aggregate output ports.
Pass-Through: Indicates that the port is an input-output port that returns the data unchanged.
Variable: Indicates that the port can store values or calculations to use in an expression. Variable ports cannot be input or output ports. They pass data within the transformation only.
Expression: The expression to aggregate the rows or groups of rows.
Default value: The default value for a port with invalid or null values.
Input Rules: A set of rules that filter the ports to include or exclude in the transformation based on port names or data type. Configure input rules when you define dynamic ports.