Pushdown optimization in informatica PowerCenter

This article will help you to understand Pushdown Optimization technique to enhance Informatica ETL performance. We will see how to implement Pushdown optimization and its limitation. Author: Dhandhaliya Dhiraj Informatica ETL Developer | SQL Developer | IICS Developer | IDQ Developer Email | Linkedin Profile   What is Pushdown Optimization? Pushdown Optimization is use to increase… Continue reading Pushdown optimization in informatica PowerCenter

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… Continue reading Performance Tuning – Aggregator Transformations

Performance Tuning – Target Bottlenecks

The most common performance bottleneck occurs when the Integration Service writes to a target database. Small checkpoint intervals, small database network packet sizes, or problems during heavy loading operations can cause target bottlenecks. How to identify a Target Bottlenecks? Read the thread statistics in the session log. When the Integration Service spends more time on the… Continue reading Performance Tuning – Target Bottlenecks