25,000+ Courses Nationwide
0345 4506120

Informatica PowerCenter Developer - Part 2

This hands-on four day Informatica PowerCenter 9.x/9.5/9.6 course is a continuation of the "PowerCenter Developer – Part 1" with advanced topics and extended Labs.

This course is designed for developers with 6 months or more of PowerCenter experience.

Select specific date to see price, venue and full details.

Learning Objectives

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.

Informatica courses are delivered as company specific training programmes, hosted at a training centre, virtually online, or on your site; tailored to your company's specific goals and objectives.


Completion of Informatica PowerCenter Developer - Level 1 course

Course Content

Course topics

  • PowerCenter Overview
  • User-Defined & Advanced Functions
  • Pivoting Data
  • Stored Procedure & SQL Transformations
  • Transaction Processing
  • Transaction Control Transform
  • Workflow & Task Recovery
  • Command Line Utilities
  • Performance Tuning: Methodology
  • Performance Tuning: Mapping Design
  • Performance Tuning: Caching & Memory Optimization
  • Performance Tuning: Partitions

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


We work with the best