Database Reference
In-Depth Information
Using Sorted Input
It is always recommended that we pass the
Sorted Input
to the Aggregator transformation,
as this will enhance performance. When you pass the sorted input to the Aggregator trans-
formation, Integration Service enhances the performance by storing less data in the cache.
When you pass unsorted data, the Aggregator transformation stores all the data in the
cache, which takes more time. When you pass the sorted data to the Aggregator transform-
ation, it stores comparatively less data. The aggregator passes the result of each group as
soon as the data for a particular group is received.
Note that the Aggregator transformation cannot perform the operation of sorting the data. It
will only internally sort the data for the purpose of calculations. When you pass the sorted
data to the Aggregator transformation, check the
Sorted Input
option in the properties, as
shown in the following screenshot:
