Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1 Training Course

Course Introduction

• Course Objectives

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)
• Normalizing flat file outputs
• Denormalizing with unconnected Lookups
• Denormalizing with the Aggregator (conditional clause and local variables)

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

• Details are not available.

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)

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

Using XML

• 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