How can we improve performance of aggregator transformation?

Question

What can we do to improve the performance of Informatica Aggregator Transformation?

Answer 1

1. Sort the data before passing into aggregator. The integration service uses memory to process the aggregator transformation and it does not use cache memory.
2. Filter the unwanted data before aggregating.
3. Limit the number of input/output or output ports to reduce the amount of data the aggregator transformation stores in the data cache.
4. When data is sorted in that case data will read and aggregate for that group no staging will happen. Here parallel operation happen while in not sorted data sequential operation will happen.