Advanced Boot Camp for Developers Informatica PowerCenter 9.6.x

PT22118
Summary
Teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in PowerCenter Version 9.6.x. This course builds on the four-day Foundation boot camp course.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for ETL Developers with a previous PowerCenter Experience.
Topics
  • Introduction
  • Mapping Techniques – local variables
  • Mapping Techniques - Pivoting data
  • Mapping techniques - self-joins
  • Mapping Techniques – Lookup Transformation
  • Mapping Techniques – Surrogate Keys
  • Mapping Techniques - other
  • Advanced Parameter usage
  • Mapping Templates
  • Performance Tuning
  • Mapping Templates
  • Using XML (optional)
  • Review of command line utilities

Related Scheduled Courses