Increase performance of aggregate processing using in-built incremental aggregation functionality in Informatica PowerCenter.
Incremental aggregation option can be used to improve performance for Aggregator transformation, provided the changes from the source data can be captured incrementally.
This allows the Integration Service to update the target incrementally, rather than forcing it to process the entire source and recalculate the same data each time you run the session.
When the session runs with incremental aggregation enabled for the first time, you use the entire source. This allows the Integration Service to read and store the necessary aggregate data. When you run the session again the Integration Service then processes the new data and updates the target accordingly.
You can download this listing as part of the Bundle : Data Warehouse.