Data Warehousing course for freshers by Acharya IT

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