Tag: Aggregator

Performance Tuning – Aggregator Transformations

No Picture

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…

Read More »

Informatica certification – Aggregator Transformation

No Picture

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

Read More »

How to remove duplicate records Using Aggregator

No Picture

How to remove duplicate records Using Aggregator There are couple of options available in informatica to remove duplicate records from the source.  For Relational Tables 1. Source Qualifier > ‘SELECT DISTINCT’ option 2. Source Qualifier > SQL override…

Read More »

Aggregator Transformation Overview

No Picture

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…

Read More »