How can U improve session performance in aggregator transformation?

                                                                                                                                                                      

Scenario:

How can U improve session performance in aggregator transformation?

Solution:

You can use the following guidelines to optimize the performance of an Aggregator transformation.

Use sorted input to decrease the use of aggregate caches.

Sorted input reduces the amount of data cached during the session and improves session performance. Use this option with the Sorter transformation to pass sorted data to the Aggregator transformation.

Limit connected input/output or output ports.

Limit the number of connected input/output or output ports to reduce the amount of data the Aggregator transformation stores in the data cache.

Filter before aggregating.

If you use a Filter transformation in the mapping place the transformation before the Aggregator transformation to reduce unnecessary aggregation.