Aggregator Transformation
Use the Aggregator transformation to perform aggregate calculations, such as averages and sums, on groups of data.
When the Mapping Configuration task performs aggregate calculations, the task stores data in groups in an aggregate cache.