Introduction
Course Objectives
Using XML (optional)
Overview
XML definitions
Using XML sources and targets
Using the XML editor
Midstream XML transformations
Lab: Using XML
Mapping Techniques-local variables
Using local variables: self and forward references
Mapping techniques-pivoting data
Using the Normalizer transformation (level of occurs, generated keys, examples)
Using XML normalized source qualifiers (optional)
Normalizing flat file outputs
Denormalizing with unconnected Lookups
Denormalizing with the Aggregator (conditional clause and local variables)
Creating XML denormalized views with the pivot feature (optional)
Mapping Techniques-self-joins
Using a Joiner with the sorted input property
Mapping Techniques-Lookup Transformation
Using dynamic caching
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 stores procedures
Transaction Control transformation and commit points
Transaction scope
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
Lab: session partitioning
Review of command line utilities
Infacmd
Pmcmd
pmrep