PowerCenter Performance Tuning and Optimization (PCPTO)

This two day course teaches students on how 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 attendees 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.
After successfully completing this course, students should be able 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
Target Audience
  • Developer
Show details
1. Performance Tuning Basics
  • Describe performance tuning methodology
  • Define Benchmarking
  • Thread Statistics and performance counters
  • Describe bottlenecks at various levels
  • Define optimization and scalability
2. Bottlenecks
  • Identify source, target and mapping bottlenecks
  • Optimize source, target, mapping, and transformations
  • Mapping best practices
3. Memory Optimization
  • Anatomy of a session
  • Session Memory calculation
  • Session-level memory optimization
  • Tune transformation caches
4. Partitions
  • Partition Methodology
  • Partition types with use cases
  • Cache Partitioning
  • PowerCenter Smart Parallelism
5. Server Sizing and System Optimization
  • Various methods for Sizing PowerCenter Server
  • Identify System Bottleneck
  • System Optimization – Windows/Unix
6. Integration Service On Grid
  • Create and configure a Grid
  • Load Balancer & functionality
  • Workflow on Grid
  • Session on Grid
  • Dynamic Partitioning
  • Load balancer tracing