Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1 Training Course

Course Introduction

• Course Objectives

Mapping Techniques – Local Variables

• Utilizing local variables: self-references and forward references

Mapping Techniques – Pivoting Data

• Employing the Normalizer transformation (occurrence levels, generated keys, and examples)
• Normalizing flat file outputs
• Denormalizing via unconnected Lookups
• Denormalizing using the Aggregator (conditional clauses and local variables)

Mapping Techniques – Self-Joins

• Utilizing a Joiner with the sorted input property

Mapping Techniques – Lookup Transformations

• Implementing dynamic caching
• Pipeline lookups
• Lab: Self-join, Dynamic Lookup, and Denormalization

Mapping Techniques – Surrogate Keys

• Utilizing the Sequence Generator transformation
• Using triggers, GUIDs, or update overrides

Mapping Techniques – Other Topics

• Executing stored procedures
• Transaction Control transformation and commit points
• Transaction scope

Advanced Parameter Usage

• Details are not available.

Mapping Templates

• Slowly Changing Dimension (SCD) updates (Type 1, 2, 3, and mixed)
• Lab: Dimensional updates
• Data validation and error handling
• Comparing two tables' contents to extract differences
• Creating parameter files
• Lab: Parameter files

Performance Tuning

• Understanding PowerCenter’s architecture
• Establishing baseline metrics
• Leveraging performance counters
• Identifying bottlenecks
• Optimizing target and source components
• Tuning blocking transformations
• Tuning Lookup transformations
• Lab: Mapping tuning
• Optimizing sessions, caches, and memory
• Utilizing session partitioning
• Tuning workflows
• Executing multiple instances of the same workflow
• Running a session or workflow on a grid
• Lab: Session partitioning
• Using PushDown optimization (optional)

Mapping Templates

• Slowly Changing Dimension (SCD) updates (Type 1, 2, 3, and mixed)
• Lab: Dimensional updates
• Data validation and error handling
• Comparing two tables' contents to extract differences
• Creating parameter files
• Lab: Parameter files

Working with XML

• Overview
• XML definitions
• Using XML sources and targets
• Utilizing the XML editor
• Midstream XML transformations
• Lab: Using XML

Review of Command Line Utilities

• Infacmd
• pmcmd
• pmrep