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… Continue reading Performance Tuning – Aggregator Transformations
Tag: Aggregator
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… Continue reading Informatica certification – Aggregator Transformation
How to remove duplicate records Using Aggregator
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… Continue reading How to remove duplicate records Using Aggregator
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… Continue reading Aggregator Transformation Overview