- Basic understanding of SQL
Informatica PowerCenter is a collection of tools for creating, executing, monitoring and scheduling ETL processes. ETL processes include Extracting data from its source, Transforming it and Loading it into a target data warehouse.
In this instructor-led, live training, participants will learn how to use PowerCenter Designer, Workflow Manager and Workflow Monitor as they step through the process of creating source and target definitions, transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data.
Audience
- Data integration developers
- Database developers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Introduction
Informatica PowerCenter - An Overview
Data Integration and Data Warehousing Fundamentals
PowerCenter Transformations
PowerCenter Tasks & Workflows
Advanced Transformations, Techniques & Reusability Features
Joins and Link Conditions
Using the Debugger
Sequence Generators, Lookups and Caching
Update Strategies, Routers and Overrides
Sorter, Aggregator
Mapping Design Workshop
Workflow Design Workshop
Closing Remarks