Informatica
Informatica in Data warehouse Concepts

What is Data Warehouse?
Data Mart
OLAP VS OLTP
Data Warehouse Architecture (Basic)
Data Warehouse Architecture (with a Staging Area)
Dimensional Modelling
Star Schema
Snowflake Schema
Dimension
Fact
Slowly Changing Dimension
Informatica in Introduction to informatica PowerCenter

PowerCenter 9 architecture
Extraction, Transformation and loading process
PowerCenter tools: Designer, Workflow manager
Workflow Monitor, Repository Manager
Informatica Administration Console
Repository Server and agent
Repository maintenance
Repository Server Administration Console
Security, Repository, privileges and folder permissions
Metadata extensions
Informatica in PowerCenter Components

Designer
Repository Manager
Workflow Manager
Workflow Monitor
Informatica in Informatica Concepts and Overview

Informatica Architecture
Source Qualifier
Transformations
Active and Passive Transformations
Mappings
Mapplets
Sessions
Tasks
Informatica in Sources

Relational Tables (Oracle)
Flat Files (fixeD width, Delimiter Files)
Xml Files
Informatica in Targets

Working with Relational Targets
Working with Flat file Targets
Informatica in Transformations

Expression
Lookup
Sequence Generator
Filter
Joiner
Sorter
Stored Procedure
Union
Router
Aggregator
Update Strategy
Expression
Informatica in Debugging Mappings

Informatica in Mappings & Mapplets

Mapping Variables & Parameters
Working with Mapping Wizards
Informatica in Workflow Manger

Server Architecture
Workflows, Worklets & Sessions
Tasks, Assignments, Events, Command etc
Informatica in Performance Tuning

Informatica Tuning (Source, target, mapping & Session)
Informatica in Project – Case Study

Informatica in Project – Review and Assignment