Performance Tuning – Aggregator Transformations

Aggregator transformations often slow performance because they must group data before processing it. Aggregator transformations need additional memory to hold intermediate group results. Use the following guidelines to optimize the performance of an Aggregator transformation: Group by simple columns. Use sorted input. Use incremental aggregation. Filter data before you aggregate it. Limit port connections. Grouping […]

Read More

Informatica certification – Aggregator Transformation

Aggregator Transformation – My Notes  What is the use of Aggregator Transformation? Ans:- Aggregator transformation can be used to aggregate calculations (Avg, Sum, Max ..) on groups. Since its changing the number of rows its an active transformation. What are the Components of the Aggregator Transformation? Ans:- Aggregate cache, Aggregate expression, Group by port & […]

Read More

Aggregator Transformation Overview

Aggregator Transformation Overview  The Aggregator transformation performs aggregate calculations, such as average, Sum, Max & Min etc. The Aggregator is an active transformation that changes the number of rows in the pipeline. The Integration Service performs the aggregate calculation on groups. The Integration Service then passes the last row received, along with the results of the aggregation. […]

Read More