PowerCenter: Developer, Level 2 - onDemand

  • onDemand
  • Data Integration
  • Self-Paced

This course is applicable to software version 10.1. Enhance your developer skills with advanced techniques and functions for PowerCenter. This course focuses on additional transformations and transaction controls, as well as, teaches performance tuning and troubleshooting for an optimized PowerCenter environment.

Course Overview & Agenda

Please note:

This is an onDemand training course with Labs. Course Content is available for 90 days after purchase. Labs are activated at the time of registration and are available for 90 days or until all lab hours are consumed.


After successfully completing this course, students should be able to:

Understand the Informatica PowerCenter architecture

Determine the structure and use of PowerCenter Parameter Files

Implement user-defined and advanced functions

Normalize and Denormalize data using PowerCenter

Use the Lookup transformation in Dynamic mode

Call a SQL stored procedure from a PowerCenter mapping

Create and configure a SQL transformation and its two modes of use

Design error handling strategies appropriate for the intended purpose of a workflow

Make use of the PowerCenter source-based, target-based, and user-based transaction control

Utilize constraint-based loading in databases with referential integrity constraints

Use the Transaction Control transformation for data-driven RDBMS transaction control

Determine the proper use of built-in and optional, mapping-design recovery capabilities

Build batch files that use PMCMD and PMREP command line programs

Apply PowerCenter Performance Tuning Methodology

Describe the effect of mapping design on performance and apply these design principles to a mapping

Calculate how much memory a session uses and tune session-level memory

Apply partitions, distribute the data and optimize the CPU memory usage

Available Languages



PowerCenter 10: Developer, Level 1

Enroll in PowerCenter 10: Developer, Level 2

Add to cart to review pricing