Advanced Boot Camp for Developers Infomatica PowerCenter 9.5.1

The Advanced Boot Camp for Developers Informatica PowerCenter 9.5.1 course is a hands-on, instructor-led course designed to provide developers with the skills and knowledge required to design and build data integration solutions using the Informatica PowerCenter Desktop and Server components. This course covers mapping design, debugging and job performance optimization as well as control flow and workflow management. In addition, students get an introduction to advanced integration solutions, as well as service and process management. The course includes lectures, workshops, on-site training and full use of the Informatica products.

The course is intended for informatica developers responsible for load data into target systems and for developing mappings of the data. The Advanced Boot Camp for Developers Informatica PowerCenter 9.5.1 course is aimed at enabling developers to become more productive, efficient and confident when designing PowerCenter solutions. Upon completion, participants should have a good working knowledge of PowerCenter Server as well data integration solutions.

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