上QQ阅读APP看书，第一时间看更新
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.
Note that aggregator transformation does not sort the data. If you have unsorted data, use sorter transformation to sort the data, and then pass the sorted data to the aggregator transformation to enhance the performance.
When you pass the sorted data to the aggregator transformation, check the Sorted Input option in the properties as shown in the following screenshot:
