This four day, instructor-led course introduces students to Informatica PowerCenter 9.6/10.x through lecture and hands-on exercises. The course is designed for Database Developers who are new to Informatica PowerCenter. Informatica PowerCenter is a collection of thick client workbench tools that Developers can use to create, execute, monitor and schedule ETL processes. The course will introduce attendees to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. They will develop cleansing, formatting, sorting and aggregating procedures. They can learn how to use routers, update strategies, mapping parameters /variables and overrides. This course will cover many different types of lookups, such as cached, persistent, and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL.
There are no prerequisites for this course.
4 Days/Lecture & Lab
This course is designed for Data Integration developers with little or no experience of PowerCenter.
- An Overview of Informatica PowerCenter 9.6/10.x
- ETL Fundamentals
- Trouble Shooting
- PowerCenter Transformations, Tasks, and Reusability
- Features and Techniques
- Joins and Link Conditions
- Using the Debugger
- Sequence Generators, Lookups, and Caching
- Update Strategies, Routers, and Overrides
- Sorter, Aggregator, Unconnected Lookups, Mapping Parameter/Variables, and Mapplets/Worklets
- Mapping Design Workshop
- Workflow Design Workshop