The Aggregator transformation is an active transformation and has the following components :
- Aggregate expression:This expression is given in the Output port and it can include non-aggregate expressions and conditional clauses.
- Group by port:Used to create groups . It can be any input, input/output, output, or variable port.
- Sorted input:In order to use sorted input pass data to the Aggregator transformation which is sorted by group by port either in ascending or descending order. Sorted input is used to improve session performance.
- Aggregate cache:The Integration Service stores data in the aggregate cache until it completes aggregate calculations. In index cache it stores the group values and row data in the data cache