Batch
Date: May 4th & 5th @ 9:00AM
Faculty: Mr. Srikanth
Duration:
2 Days Workshop
Fee : 4000/-INR
Location
: S.R Nagar, Hyderabad.
Venue
:
DURGA Software Solutions At SR Nagar
Canara bank building 2nd floor,
near S. R Nagar Ploce Station,
Hyderabad-500038.
Contact : 97 03 08 96 96
Syllabus:
1.
INFORMATICA POWERCENTER 9.1
DATAWARE HOUSING FUNDAMENTALS
1. What is Database?
2. What is Data Warehousing?
3. Difference between OLTP Database and DWH.
4. ETL FUNDAMENTALS.
i) Data Extraction
ii) Data Transformation
iii) Data Loading
5. What is ETL Client?
6. DataMart and Types of Data Marts.
7. DataWareHouse-Database Design.
i) Star Schema.
ii) Snow Flake Schema.
8. OLAP and Types of OLAPs
9. DataWareHouse Architecture.
INFORMATICA POWERCENTER 9.1
Informatica Client Installation
Informatica Server Installation
1. Power Center Components.
• Power Center Clients
• Power Center Repository.
• Power Center Domain
• Integration service
• Repository Service
• Administration Console
2. Difference between Informatica 8.X and 9.X
3. Power Center Architecture
4. Integration Service Architecture
TRANSFORMATIONS
a). ACTIVE TRANSFORMATIONS.
Filter Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Union Transformation
Sorter Transformation
Rank Transformation
Transaction Control Transformation
Update Strategy Transformation
Normalizer Transformation
Source Qualifier Transformation
SQL Transformation.
b). PASSIVE TRANSFORMATION
EXPRESSION TRANSFORMATION
SEQUENCE GENERATOR TRANSFORMATION
STORED PROCEDURE TRANSFORMATION
LOOKUP TRANSFORMATION (Upgradations in 9.X)
XML SOURCE Qualifier Transformation.
c). CONNECTED AND UNCONNECTED TRANSFORMATIONS.
d). FLAT FILES AND ITS TYPES.
e). FLAT FILES TO EXCEL LOAD.
f). EXCELTO FLAT FILES LOAD.
g). FLAT FILES TO TABLELOAD.
h). TABLETO FLAT FILELOAD.