Informatica Performance Tuning Guide, Identify Performance Bottlenecks - Part 2

Informatica Performance Tuning Guide, Identify Performance Bottlenecks - Part 2

In our previous article in the performance tuning series, we covered the basics of Informatica performance tuning process and the session anatomy. In this article we will cover the methods to identify different performance bottlenecks. Here we will use session thread statistics, session performance counter and workflow monitor properties to help us understand the bottlenecks.

Continue Reading

Informatica Performance Tuning Guide, Tuning and Bottleneck Overview - Part 1

Informatica Performance Tuning Guide, Tuning and Bottleneck Overview - Part 1

Performance tuning process identifies the bottlenecks and eliminate it to get a better acceptable ETL load time. Tuning starts with the identification of bottlenecks in source, target, mapping and further to session tuning. It might need further tuning on the system resources on which the Informatica PowerCenter Services are running.

Continue Reading

Dynamic Partitioning to Increase Parallelism Based on Resources Availability

Dynamic Partitioning to Increase Parallelism Based on Resources Availability

Informatica PowerCenter session partition can be used to process data in parallel and achieve faster data delivery. Using Dynamic Session Partitioning capability, PowerCenter can dynamically decide the degree of parallelism. The Integration Service scales the number of session partitions at run time based on factors such as source database partitions or the number of CPUs on the node resulting significant performance improvement.

Continue Reading

Informatica PowerCenter Pushdown Optimization a Hybrid ELT Approach

Informatica PowerCenter Pushdown Optimization a Hybrid ELT Approach

Informatica Pushdown Optimization Option increases performance by providing the flexibility to push transformation processing to the most appropriate processing resource. Using Pushdown Optimization, data transformation logic can be pushed to source database or target database or through the PowerCenter server.  This gives the option for the ETL architect to choose the best of the available resources for data processing.

Continue Reading

Implementing Informatica PowerCenter Session Partitioning Algorithms

Implementing Informatica PowerCenter Session Partitioning Algorithms

Informatica PowerCenter Session Partitioning can be effectively used for parallel data processing and achieve faster data delivery. Parallel data processing performance is heavily depending on the additional hardware power available. In additional to that, it is important to choose the appropriate partitioning algorithm or partition type. In this article lets discuss the optimal session partition settings.

Continue Reading