How to improve the performance of an Aggregator transformation?

• Use sorted input: Sorted input reduces the amount of data cached during the session and improves session performance. Hence use Sorter transformation and sort the data and pass to the Aggregator transformation.

• Less number of Input\Output Ports:Use less number of connected input/output or output ports to reduce the amount of data .The Aggregator transformation stores in the data cache.

• User Filter:In case if you are using Filter transformation use it before aggregator.This helps the Aggregator transformation to reduce unnecessary aggregation