Aggregator transformation is an active transformation is used to performs aggregate calculations like sum, average, etc. For example, if you want to calculate the sum of salaries of all employees department wise, we can use the Aggregator Transformation. ... For this, we require a new column to store this sum.

Why do we use aggregator transformation in Informatica?

Use the Aggregator transformation to perform aggregate calculations, such as averages and sums, on groups of data. task performs aggregate calculations, the task stores data in groups in an aggregate cache. To use the Aggregator transformation, you need the appropriate license.

What is the use of aggregator cache file?

The Integration Service uses cache memory to process Aggregator transformations with unsorted input. When you run the session, the Integration Service stores data in memory until it completes the aggregate calculations.