Data Warehousing with Informatica PowerCenter v9.x

This course is designed to introduce and put into practice sound data warehousing concepts, from schema designs to requirement documents to implementation. This class also focuses on using Informatica PowerCenter as the data warehouse ETL tool of choice.
Some experience with Visio and ERwin is helpful
5 Days/Lecture & Lab
This course is designed for ETL developers with no previous PowerCenter experience.
  • Introduction and product overview
  • Data warehouse introduction and design
  • Building the Data Model
  • Introduction to PowerCenter
  • Designer Overview
  • Workflow Manager Overview
  • Data Modeling with Erwin
  • Data Movement Diagrams
  • Building the Data Mart
  • Mappings Primer
  • Sessions Primer
  • Debugger Primer
  • Transformation Objects
  • Mapping Parameters and Variables
  • Working with Transformation Objects
  • More Transformation Objects
  • PowerCenter Best Practices
  • Repository Manager
  • Slowly Changing Dimensions
  • Test Plans
  • Workflow Manager
  • Workflow monitor
  • Migrating to Production
  • Loading Data

Related Scheduled Courses