Aggregator transformations often slow performance because they group data before processing it. Aggregator transformations need additional memory to hold intermediate group results.
For optimal performance, place Aggregator transformations as close to the Source transformation as possible.
Use the following guidelines to optimize the performance of an Aggregator transformation: