Day One
Course Introduction
Course Objectives
Introduction to Informatica PowerCenter
Architecture & Connections
Development Steps
Mapping & Debugger Demonstration
Designer Overview
Interface
Connections
Tools
Creating a mapping
Working With Sources & Targets
Importing & editing sources & targets
Previewing data
Mappings & Transformation Objects
Mapping concepts
Creating & editing transformations
Transformation Objects In Depth
Source Qualifier
Expression
Filter
Aggregator
Target Instance
Designer: Clearing the Workspace
Student Labs
Expression and Aggregator Transformations
Working with Flat Files
Importing & editing flat file sources & targets
Sharing and Reusing Designer Objects
Reusable transformations
Working with shortcuts
Using the Debugger
Debugger process
Breakpoints
Debugger strategies
Review Quiz
Day Two
Designer: Arranging the Workspace
Student Labs
Flat files, Lookups, Reusable Transformations
Transformation Objects In Depth
Stored Procedure
Router
Designer: Autolink
Student Labs
Stored Procedure and Router Transformation
Transformation Objects In Depth
Sorter
Local Variables
Using local variables
Port evaluation
Designer: Select link path
Student Labs
Local Variables, Sorter Transformation
Transformation Objects In Depth
Rank
String Functions
Designer: Propagate attributes
Student Labs
Rank Transformation, Flat File Target
Transformation Objects In Depth
Joiner
Getting Help
Designer: Comparing Objects
Student Labs
Joiner Transformation
Review Quiz
Day Three
Designer: Custom Tools
Student Labs
Flat File Lookup, Self-Join
Transformation Objects In Depth
Transaction Control
Designer: View Dependencies
Student Labs
Transaction-Based Processing
Transformation Objects In Depth
Union
Student Labs
Union Transformation
Transformation Objects In Depth
Normalizer
Mapplets
Designer: Foreign Key Relationships
Student Labs
Mapplets
Transformation Objects In Depth
Update Strategy
Sequence Generator
Slowly-Changing Dimensions
Student Labs
Slowly-Changing Dimensions – Type 1
Review Quiz
Day Four
Student Labs
Slowly-Changing Dimensions – Type 2
Workflow Manager
Menus & tools
5 steps to creating a workflow
Workflow Monitor
Interface
Controlling workflows and tasks
Viewing logs & session properties
Gantt Chart View & Task View
Workflow Tasks
Tasks
Cast
Common Properties
Variables
Session
Student Labs
Simple Workflow
Workflow Tasks
Command
Email
Decision
Assignment
Timer
Control
Event Raise & Wait
Worklets
Student Labs
Worklets and Complex Workflow
Mapping Parameters & Variables
Parameter Files
Student Labs
Mapping Parameters and Variables
Repository Manager
Interface
Managing users & privileges
Extending metadata
Team Based Development
Version Control 101
Checking Out & Checking In Objects
Creating Labels
Creating Repository Queries
Optional Features
Server Grids
Data Quality Option
Data Profiling