Course Duration in Hours
80
80
DataWareHousing Concepts
What is Data Ware House?
Difference between OLTP and DataWare Housing
Data Acquisition
Data Extraction
Data Transformation
Data Loading
Data Marts
Dependent Data Mart
Independent Data Mart
Dataware house Design
Star Schema
Snow Flake Schema
Informatica client tools
Designe
Workflow Manager
Work flow monitor
Informatica Transformations
a) Expression Transformation
b) Lookup Transformation
c) Sequence Generator Transformation
d) Filter Transformation
e) Joiner Transformation
f) Sorter Transformation
g) Procedural Transformation
h) Router Transformation
i) Aggregator Transformation
j) Update Strategy Transformation
k) Union Transformation
L) Rank Transformation
M) Transaction Control Transformation
N) Normalizer Transformation
O) Source Qualifier Transformation
P) Stored Procedure Transformation
Q) XML Source Qualifier Transformation
Mapplets
Reusable Transformations
SCD(slowly changing dimension)
Type-1 SCD
Type-2 SCD
Type-3 SCD
Tasks
Advanced Concepts
SQL Concepts
UNIX concepts
Informatica Interview Questions, Scenarios and Problems
Responsibilities of Informatica Developer
Any Degree
Acharya IT, BTM Ist Stage (Bangalore),Bangalore,IN