Course Outline

 

 

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
 28 Hours

Upcoming Courses