Using Sorted Input

It is always recommended that we pass sorted input to aggregator transformation as this will enhance the performance. When you pass the sorted input to aggregator transformation, integration services enhance the performance by storing less data in cache. When you pass unsorted data, aggregator transformation stores all the data into cache, which takes more time. When you pass the sorted data to aggregator transformation, aggregator transformation stores comparatively less data. The aggregator passes the result of each group as soon as the data for the particular group is received.

When you pass the sorted data to the aggregator transformation, check the Sorted Input option in the properties as shown in the following screenshot: