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… Continue reading Pushdown optimization in informatica PowerCenter
Category: Performance Tuning
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… 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… Continue reading Performance Tuning – Target Bottlenecks