Loading Course Schedule...
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