Attendees:

Prerequisites:

Windows GUI, RDBMS concepts

General Objectives:

The objective of this training is to:

• Expose the core features of Informatica PowerCenter 8 through lecture and a workshop.
• Gain insight into the data integration platform.
• Understand mappings and their objects.
• Run, monitor and troubleshoot workflows.

Agenda:

• Data Integration Concepts
• PowerCenter Architecture
• PowerCenter Components and User Interface
• Source Qualifier
• Expression, Filter, File Lists, Workflow Scheduler And Debugger
• Joins and Features
• Lookups and Reusable Transformations
• Debugger
• Sequence Generator
• Lookup Caching
• Sorter, Aggregator and Self-Join
• Router, Update Strategy and Overrides
• Error Logging
• Unconnected Lookup, Parameters and Variables
• Mapplets
• Workflow Variables and Tasks
• More Tasks and Reusability
• Worklets and More Tasks
• Beyond your power