Loading Course Schedule...
PT15476
Training Summary
Teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in PowerCenter version 10.x. This course builds on the four-day Foundation boot camp course. Additional topics on PWC V10 New Features and administration will also be discussed.
Prerequisites
Before taking this course, you should have some PowerCenter experience.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for PowerCenter developers with some experience.
Course 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