Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4

This course teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in PowerCenter version 9.x.

Course Outline

This course teaches advanced mapping techniques and performance tuning and provides a thorough review of session partitioning features found in PowerCenter version 9.x.

  • Introduction
  • Mapping Techniques- local variables
  • Mapping Techniques - pivoting data
  • Mapping Techniques - self-joins
  • Mapping Techniques - Lookup Transformation
  • Lab: Self-join, Dynamic Lookup and Denormalizing Mapping Techniques - surrogate keys
  • Mapping Techniques - other
  • Advanced Parameter usage
  • Mapping Templates
  • Performance Tuning

This course is designed for PowerCenter developers with some PowerCenter experience.

Course Outline

I. Introduction

A. Course objectives

II. Mapping Techniques - local variables
A. Using local variables: self and forward references

III. Mapping Techniques - pivoting data

A. Using the Normalizer transformation (level of occurs, generated keys, examples)
B. Normalizing flat file outputs
C. Denormalizing with unconnected Lookups
D. Denormalizing with the Aggregator (conditional clause and local variables)

IV. Mapping Techniques - self-joins
A. Using a Joiner with the sorted input property

V. Mapping Techniques - Lookup Transformation
A. Using dynamic caching
B. Pipeline lookups

VI. Lab: Self-join, Dynamic Lookup and Denormalizing

VII. Mapping Techniques - surrogate keys

A. Using the Sequence generator transformation
B. Using a trigger, GUID or update overrides

VIII. Mapping Techniques - other
A. Calling stored procedures
B. Transaction Control transformation and commit points
C. Transaction scope

IX. Advanced Parameter usage
A. Sharing mapping parameters between sessions

X. Mapping Templates
A. Slowly changing dimension updates (type 1, 2, 3 and mixed)
B. Lab: dimensional updates
C. Data validation and error trapping
D. Comparing the contents of two tables and extracting differences
E. Building parameter files
F. Lab: parameter files

XI. Performance Tuning
A. Understanding PowerCenter's architecture
B. Getting baseline numbers

Prerequisites & Certificates

It is required that students take the four-day boot camp course before attending this class.

Certificates offered

Certificate of Completion

Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
Map & Reviews
Protech Training
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I took the training remotely so I cannot comment on some of the questions. I think that this seminar has too much content to squeeze it into one week.... might be better as a two week course?
Reviewed by 2013
found the material very helpful - although there was a lot of material covered - the pace was well set. Would definitely recommend people to have explored Microsoft Access beforehand to be familiarized with the program before taking the course. I would imagine someone without any exposure would find it confusing. Environment really good - people very, very nice and helpful. Would definitely take the next level of access with the same training facility.
Reviewed by 2013
I was not in the physical classroom. Feedback centered around online training would be good because now I have to rate items that I was not present for. Those items are getting half a star because I was not there to rate them. The course material must go through an editing process. There are a lot of grammar mistakes, but also a lot of actual procedure/activity mistakes.
Reviewed by 2012

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 196 times.