Learning Informatica PowerCenter 10.x - Second Edition

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 ...