Informatica Training at Futurepointtech.com

  Post ad  
Posted on 25-Oct-2019 12:48
Views 35

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.
iii) Galaxy Schema.
8. OLAP and Types of OLAPs
9. DataWareHouse Architecture.



INFORMATICA POWERCENTER 9.1


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.


POWER CENTER ADVANCED

1). Unconnected lookup Transformation
2). Unconnected Stored Procedure to Create and Drop Index
3). Mapplet And Types Of Mapplets
4). Defining Reusable Transformations.

http://www.futurepointtech.com/informatica-training.html

Drop a mail info@futurepointtech.com we will get in to

Address Plot No:60, 2nd Floor ,Western Hills, Opp: Sri Chaitanya Junior Kalasala Behind Arjuna Theatre, Hyd