INFORMATICA Online Training Course Content

Duration: 3-4 Weeks

Overview of Data Warehousing

Introduction to Data warehouse (What/Why/How)
Star schema/Snowflake schema/Galaxy schema
Dimension/Fact Tables.
Slowly Changing Dimensions and its types.

 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 Definitions
Transformation Concepts (Types, Classifications, Basic uses)
ODBC & Relational Connections
Using Flat Files
Using XML Files
Transformations:
Filter
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)

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
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

Exclusives

Multiple Exercises
Real Time Scenarios
DEMO PROJECT
Concepts of UNIX Required for Informatica
Assistance in Resume Building
Job Oriented Training

  1. Send us which course you want to join.
Have a Query?