UMBC Training Centers logo

Informatica PowerCenter 8.x Level II Developer


Course Description | Outline | IT Home


This four-day, instructor-led course complements and extends “PowerCenter 8 Level I Developer” with advanced topics and extended labs. The course is intended for developers with more than Three months of PowerCenter 8 experience. Topics covered include: Advanced Mapping Techniques; Advanced Workflow Techniques; Transaction Control; Workflow Recovery; Error Handling; Performance Tuning; Stored Procedures and Custom Transformations; Repository Reporting; Memory Allocation; and Pipeline Partitioning.

Course Objectives:

  • Describe the PowerCenter 8 architecture
  • Given a mapping specification, build a corresponding mapping, using the techniques including: variables and parameter files; dynamic caching; data-driven and incremental aggregation; denormalization; user-defined and custom functions
  • Control workflow behavior with restart junctions, control tables, workflow variables, and dynamic scheduling
  • Configure workflows for recovery
  • Use transaction control to manage writing to targets
  • Configure PowerCenter’s handling of data errors
  • Manage objects in one or more repositories
  • Optimize PowerCenter’s memory usage
  • Using a standardized methodology, optimize the performance of PowerCenter in your environment
  • Use partitions and stages to improve performance


Students should have completed our Informatica PowerCenter 8.x Level I course, or have equivalent experience.


4 Days

Contact Information

E-mail or call (443) 692-6599:

  • if you have any questions about this course,
  • to be notified when this course and any closely related courses are scheduled for open enrollment,
  • to request a quote for group training at your location or ours.