Introduction Course objectives Mapping Techniques – local variables Using local variables: self and forward references

Mapping Techniques – self-joins Using a Joiner with the sorted input property

Mapping Techniques – Lookup Transformation Using dynamic caching Pipeline lookups

Lab: Self-join, Dynamic Lookup and Denormalizing Mapping Techniques – surrogate keys Using the Sequence generator transformation Using a trigger, GUID or update overrides

Mapping Techniques – other Calling stored procedures Transaction Control transformation and commit points Transaction scope

Advanced Parameter usage Sharing mapping parameters between sessions

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

Performance Tuning Understanding PowerCenter’s architecture Getting baseline numbers Using performance counters Identifying bottlenecks Tuning the target and source components Tuning blocking transformations Tuning Lookup transformations Lab: tuning the mapping Tuning the session, caches and memory Using session partitioning Tuning the workflow Running multiple instances of the same workflow Running a session or a workflow on a grid Lab: session partitioning Using PushDown optimization (optional)

Using XML (optional) Overview XML definitions Using XML sources and targets Using the XML editor Midstream XML transformations

Lab: Using XML Review of command line utilities Infacmd pmcmd pmrep