Summary:

This course will introduce the student to the Informatica PowerCenter tool, and will provide an introduction to data warehousing concepts. Students will gain a clear understanding of the PowerCenter development environment. This course reinforces the concepts taught with numerous daily labs that allow the students to practice developing solutions to real world data warehousing problems. Students will leave this class with the skills and knowledge necessary to make them successful Informatica developers.

Duration:

40 Hours of Lecture and Lab

Topics:

• Designer Overview
  • Interface
  • Tools
• Workflow Manager Overview
  • Interface
  • Tools
• Workflow Monitor Overview
  • Interface
  • Logs and properties
  • Controlling workflows and tasks
• Sources and Targets
  • Relational Database
  • Flat Files
  • XML
• Mapping Transformations
  • Source Qualifier
  • Expression
  • Filter
  • Sorter
  • Rank
  • Sequence Generator
  • Update Strategy
  • Aggregator
  • Router
  • Joiner
  • Union
  • Normalizer
  • Stored Procedure
  • Java
• Mapping Tools and Functions
  • Debugger
  • Parameters and Variables
  • Substr
  • Instr
  • ReplaceChr
  • ReplaceStr
  • RegMatch
  • RegExtract
  • Port evaluation
  • Autolink
  • Propogate Attributes
• Working with the Workflow Manager
  • Workflows
  • Sessions
  • Command Tasks
  • Email Tasks
  • Decisions
  • Event Raise and Wait
  • Scheduling and Control
• Reusability
  • Reusable Sessions
  • Reusable Transformations
  • Mapplets
  • Parameter Files
• Datawarehousing Topics
  • Primary Keys
  • Foriegn Key Relationships
  • Type 1 and Type 2 warehouses
  • Fact Tables
  • Dimension Tables
  • Staging

Prerequisites:

The student should have a working knowledge of SQL as well as a basic understanding of data warehousing concepts.