1. Provide sorted input into the aggregator. Do check the sorted input property in the aggregator.2. Reduce the input/output ports in the aggregator.3.Can try increasing the cache size.
-Use sorted input to decrease the use of aggregate caches.-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 the data before aggregating it.