Day One
Course Introduction
Course Objectives
Introduction to Informatica PowerCenter
Components & Architecture
Designer Overview
Interface
Tools
Live Demo: creating and debugging a mapping
Concepts
Mappings
Sources and Targets
Transformations Objects
Transformation Objects in Depth
Source Qualifier
Expression Filter
Aggregator
Target Instance
Student Lab 1
Expression and Aggregator
Transformations
Transformation Objects in Depth
Lookup
Working with Flat Files
Importing & editing flat file sources & targets
Flat file data-types
Designer: Clearing the Workspace
Student Lab 2
Flat files, Lookups
Day Two
Review Quiz
Using the Debugger
Debugging process and strategies
Breakpoints, evaluate expressions
Designer Tips
Documenting objects
Getting help
Transformation Objects in Depth
Stored Procedure
Router
Designer: Autolink
Student Lab 3
Stored Procedure and Router Transformation
Designer: Link path
Transformation Objects in Depth
Sorter
Local Variables
Using local variables
Port evaluation
Student Lab 4
Local Variables, Sorter Transformation
Transformation Objects in Depth
Rank
Joiner
String Functions
Substr, Instr, ReplaceChr, ReplaceStr
Regmatch, RegExtract
User-Defined Functions
Student Lab 5
Joiner Transformation, String functions
Day Three
Review Quiz
Designer: Propagate attributes
Sharing and Reusing Designer Objects
Reusable transformations
Working with shortcuts
Transformation Objects in Depth
Union
Normalizer
Java Transformation
Student Lab 6
Normalizer, reusable transformations
Mapplets
Designer: Foreign Key Relationships
Student Lab 7
Mapplets
Transformation Objects in Depth
Update Strategy
Sequence Generator
Slowly-Changing Dimensions
XML
Sources and targets
Parser and generator
Editor overview
Student changing dimension type 1
Day Four
Review Quiz
Workflow Manager
Menus & tools
5 steps to creating a workflow
Session properties
Workflow Monitor
Interface
Controlling workflows and tasks
Viewing logs & session properties
Gantt Chart View & Task View
Student Lab 9
Simple Workflow
Workflow Tasks
Command
Email
Decision
Timer
Control
Event Raise & Wait
Worklets
Student Lab 10
Worklets and Complex Workflow
Parameters & Variables
In mappings
In sessions and workflows
Parameter files
Student Lab 11
Mapping Parameters and Variables
Team Based Development Overview
Version Control 101
Checking Out & Checking In Objects
Repository queries