Call : (+91) 968636 4243
Mail :

Informatica PowerCenter - Performance Tuning and Optimization

( Duration: 2 Days )

This PowerCenter - Performance Tuning and Optimization training course provides skills to optimize the performance of Informatica PowerCenter through lecture and hands-on exercises. The course is designed for advanced PowerCenter developers. The course will introduce you to the various techniques and tools to perform tasks such as isolating and optimizing bottlenecks at various levels (source, transformation, target, session and system), server sizing. This course will also cover partitions and grid in more detail.

By attending PowerCenter - Performance Tuning and Optimization workshop, delegates will learn to:

  • Describe the different types of potential bottlenecks that may affect PowerCenter’s performance
  • Describe how to isolate and optimize source, target, and engine bottlenecks
  • Apply best practices to PowerCenter mappings
  • Describe how to calculate memory used by a session and optimize session- level memory and transformation cache
  • Describe different partition types and guidelines for usage
  • Perform system optimization and server sizing
  • Understand various concepts on integration service on grid

The PowerCenter - Performance Tuning and Optimization class is ideal for:

  • Developers



Performance Tuning Basics

  • Describe performance tuning methodology
  • Define Benchmarking
  • Thread Statistics and performance counters
  • Describe bottlenecks at various levels
  • Define optimization and scalability


  • Identify source, target and mapping bottlenecks
  • Optimize source, target, mapping, and transformations
  • Mapping best practices

Memory Optimization

  • Anatomy of a session
  • Session Memory calculation
  • Session-level memory optimization
  • Tune transformation caches


  • Partition Methodology
  • Partition types with use cases
  • Cache Partitioning
  • PowerCenter Smart Parallelism

Server Sizing and System Optimization

  • Various methods for Sizing PowerCenter Server
  • Identify System Bottleneck
  • System Optimization – Windows/Unix

Integration Service On Grid

  • Create and configure a Grid
  • Load Balancer & functionality
  • Workflow on Grid
  • Session on Grid
  • Dynamic Partitioning
  • Load balancer tracing

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.