1. First follow the tutorial from Powercenter Help .
This includes totally 6 lessons.
2. If I can get Informatica PowerCenter 8 Developer training, I'll follow training agenda
I'm trying to get a on site training combine level one and two together.
PowerCenter 8 – Level I Developer
Agenda:
· Data Integration Concepts
o Data Integration
o Mapping and Transformations
o Tasks and Workflows
o Metadata
· PowerCenter Components and User Interface
o PowerCenter Architecture
o PowerCenter Client Tools
o Lab - Using the Designer and Workflow Manager
· Source Qualifier
o Source Qualifier Transformation
o Velocity Methodology
o Lab Project Overview
o Lab A - Load Payment Staging Table
o Source Qualifier Joins
o Lab B - Load Product Staging Table
o Source Pipelines
o Lab C - Load Dealership and Promotions Staging Table
· Expression, Filter, File Lists and Workflow Scheduler
o Expression Editor
o Filter Transformation
o File Lists
o Workflow Scheduler
o Lab - Load the Customer Staging Table
· Joins, Features and Techniques I
o Joiner Transformation
o Shortcuts
o Lab A - Load Sales Transaction Staging Table
o Lab B - Features and Techniques I
· Lookups and Reusable Transformations
o Lookup Transformation
o Reusable Transformations
o Lab A - Load Employee Staging Table
o Lab B - Load Date Staging Table
· Debugger
o Debugging Mappings
o Lab - Using the Debugger
· Sequence Generator
o Sequence Generator Transformation
o Lab - Load Date Dimension Table
· Lookup Caching, More Features and Techniques
o Lookup Caching
o Lab A - Load Promotions Dimension Table
o Lab B - Features and Techniques II
· Sorter, Aggregator and Self-Join
o Sorter Transformation
o Aggregator Transformation
o Active and Passive Transformations
o Data Concatenation
o Self-Join
o Lab - Reload the Employee Staging Table
· Router, Update Strategy and Overrides
o Router Transformation
o Update Strategy Transformation
o Expression Default Values
o Source Qualifier Override
o Target Override
o Session Task Mapping Overrides
o Lab - Load Employee Dimension Table
· Dynamic Lookup and Error Logging
o Dynamic Lookup
o Error Logging
o Lab - Load Customer Dimension Table
· Unconnected Lookup, Parameters and Variables
o Unconnected Lookup Transformation
o System Variables
o Mapping Parameters and Variables
o Lab - Load Sales Fact Table
· Mapplets
o Mapplets
o Lab - Load Product Daily Aggregate Table
· Mapping Design
o Designing Mappings
o Workshop
· Workflow Variables and Tasks
o Link Conditions
o Workflow Variables
o Assignment Task
o Decision Task
o Email Task
o Lab - Load Product Weekly Aggregate Table
· More Tasks and Reusability
o Event Raise Task
o Event Wait Task
o Command Task
o Reusable Tasks
o Reusable Session Task
o Reusable Session Configuration
o PMCMD Utility
· Worklets and More Tasks
o Worklets
o Timer Task
o Control Task
o Lab - Load Inventory Fact Table
· Workflow Design
o Designing Workflows
o Workshop (Optional)
PowerCenter 8 – Level II Developer
Agenda:
· Architecture Overview and High Availability
o Architectural overview
o Domains, nodes, and services
o Administration Console
o Configuring services
o High Availability
· Mapping and Session Techniques
o Mapping parameters and variables and parameter files
o File lists
o Dynamic lookup cache
o Data driven aggregation
o Incremental aggregation
o Denormalization
· Workflow Techniques
o Using Tasks
o Workflow Control and Restart
o Workflow Alerts
o Dynamic Scheduling
o Pseudo-looping techniques
· Workflow Recovery
o Workflow recovery principles
o Task recovery strategy
o Workflow recovery options
o State of operation
o Resume recovery strategy
o Recovery using the command line
· Transaction Control
o Database Transactions
o Transaction Control transformation
o PowerCenter transaction control options
o Transformation scope
· Error Handling
o Error categories
o Error logging
o Error handling strategies
· Object Queries, Object Migration, and Comparing Objects
o Creating object queries
o Migration
o Comparing objects
o Repository Reporting
o Metadata Reports
o Repository reports
· Memory Allocation
o Optimizing session memory
o Optimizing transformation caches
o Auto-cache sizing
· Performance Tuning Methodology
o Session dynamics
o Measuring performance
o Testing for bottlenecks
o Optimization techniques
· Pipeline Partitioning
o Pipeline types
o Multi-partition sessions
o Partition points and types
o Using dynamic partitioning
