4 days

Target audience

The course is designed for ETL Developers who are experienced with Informatica PowerCenter.


Database Developers with tree months or more experience with PowerCenter.
Has completed PowerCenter Level 1 Developer


This 4-Day, instructor-led course compliments and extends “PowerCenter 9.x Level 1 Developer” with advanced topics and extended Labs. This course is intended for developers with more than 6 months of PowerCenter 9 experience. Topics covered include: High Availability, Pipeline Look-up & Dynamic Look-up Expressions, SQL Transformation & Transaction Control Transformations. Additional topics include: Extended Use of Parameter Files, Use of Command Line Utilities and Mapping Architect for Visio. The course also includes an extensive series of Performance Tuning Workshops including: Methodology, Mapping Design & Cache Management with Memory Optimization.


Training is based on theory and explanations to funtionality in presented in plenum and hands-on exercises. The course material is in English but teaching is carried out in Danish.

1.  PowerCenter Overview
2.  User-Defined & Advanced Functions
3.  Pivoting Data
4.  Stored Procedure & SQL Transformations
5.  Transaction Processing
6.  Transaction Control Transform
7.  Workflow & Task Recovery
8. Command Line Utilities
9. Performance Tuning: Methodology
10.  Performance Tuning: Mapping Design
11. Performance Tuning: Caching & Memory Optimization
12. Performance Tuning: Partitions

Date and time

On demand




Kr. 22.000