Informatica Powercenter Training

Informatica Powercenter Course Reviews

The course is practical oriented. Good place for learning.

Informatica Powercenter Course Content

Overview of Data Warehousing

• Introduction to Data warehouse (What/Why/How)
• Star schema/Snowflake schema/Galaxy schema
• Dimensions/Facts tables
• Slowly Changing Dimensions and its types
• GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects

Basic ETL

• Introduction to Informatica PowerCenter
• (E)xtraction, (T)ransformation and (L)oading Process
• PowerCenter Tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor)
• Source and Target Object Definitions
• Transformation Concepts (Types, Classifications, Basic uses)
• ODBC & Relational Connections
• Working with Flatfiles
• Working with XML Files
• Transformations:
• Router
• Sequence Generator
• Rank
• Sorter
• Joiner
• Union
• Source Qualifier
• Expression
• Aggregator
• Lookup (Connected/Unconnected)
• Normalizer
• Stored Procedure (Connected/Unconnected)
• Update Strategy
• Transaction Control
• Java Transformation
• SQL Transformation (Query/Script)
• XML Parser
• XML Generator

Advanced ETL

• Different Load Types
• Slowly Changing Dimensions (Type - 1/2/3)
• Indirect Method for Loading
• Mapplets and Reusable Transformations
• Parameters and Variables (Mapping and Workflow)
• Different Types of Tasks:
• • Session
• • Email
• • Command
• • Assignment
• • Control
• • Timer
• • Decision
• • Event Wait
• • Event Raise
• Working with Links
• Worklets
• Scheduler
• Parallel and Serial Batching
• User Defined Functions
• Incremental Aggregation
• Constraint Based Loading
• Target Load Plan
• Performance Tuning
• Pushdown Optimization
• Wizards
• Partitioning
• Debugger