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.