Informatica PowerCenter 9.x Level II Developer

Program Overview

This three-day Informatica Training Program complements and extends PowerCenter 8x/9.0 Level One Developer with advanced topics and extended labs.


1. PowerCenter Overview

  • Describe the Components of the PowerCenter 8 architecture and define key terms
  • Describe PowerCenter’s optional and built-in high availability features

2. User-Defined and Advanced Functions

  • Describe User Defined Function Create Entity Types
  • Describe and implement advanced functions

3. Pivoting Data

  • Describe the use of the normalizer and aggregator transformations to normalize and denormalize data

4. Stored Procedure and the SQL Transformations

  • Describe the use of the Stored Procedure transformation in a mapping or mapplet
  • Describe the uses of the SQL transform

5. Transaction Processing

  • Describe Source based and Target based transaction controls with and without high availability option
  • Describe the use of PowerCenter constraint-based loading in databases with referential integrity constraints

6. Transaction Control Transform

  • Describe the use of the transaction control transformation for data-driven transaction control
  • Describe control when data is committed to disk or the target database

7. Workflow and Task Recovery

  • Describe workflow and task recovery with and without the high availability option
  • Recover tasks and workflows that stop, abort, or terminate
  • Explain and use PowerCenter’s built-in recovery capabilities
  • Explain the user-designed recovery techniques
  • Design error handling strategies appropriate for the intended purpose of a Workflow

8. Command Line Utilities

  • Use pmcmd to start, restart, and recover workflows
  • Use pmrep for object export, mass validation, object import, backup, and EBF migration of a unit or work

9. Performance Tuning: Methodology

  • Describe Performance counters
  • Describe Busy percentages and how they help in bottleneck isolation
  • Describe Thread utilization to identify a target bottleneck
  • Describe Thread utilization to identify a transformation bottleneck
  • Describe Thread utilization to identify a source bottleneck
  • Describe Types of target bottlenecks: database, network, disk, and PowerCenter
  • Describe Three alternatives to the update-else-insert scenario
  • Describe How transaction control impacts performance
  • Describe Types of source bottlenecks: database, network, disk, and PowerCenter
  • Describe Tune the line sequential buffer
  • Describe External loader effects on target bottlenecks

10. Performance Tuning: Mapping Design

  • Explain types of data type conversion: port-to-port, expression-to-port, and explicit
  • Identify which transformations increase or decrease the number of rows
  • Explain the performance implications of the Stored
  • Procedure vs. the SQL transformation

11. Performance Tuning: Caching and Memory Optimization

  • Describe data caching and RAM memory optimization techniques to improve session performance
  • Describe DTM buffer pool optimization

12. Performance Tuning: Partitions

  • Describe how pipelines and partitions affect performance
  • Describe three options for merging partitions: sequential, concurrent, and file list
  • Describe how partitioning affects the DTM buffer pool


Who should attend?

Suitable candidates for this Informatica certification program are:

  • Developers who want to understand performance tuning and advance transformations.


Developers with more than six months of experience of PowerCenter 8.x/9.0.

Learning Objectives

After completing this pogram you should be able to:

  • Make use of advanced functions, transformations including Java, Pipeline and Dynamic Lookups, SQL, and Transaction Control Transformations.
  • Perform tasks like Pivoting data, Transaction control, Troubleshooting Methodology, Recovery, the use of Command Line Utilities, Mapping Architect for Visio and an extensive series of Performance tuning workshops that include Methodology, Mapping Design, Cache Management/Memory Optimization.


Delivery Method

Public classroom training led by an Informatica Instructor.



Managed Training Services (MTS)