Check with seller Informatica Online Training at FuturePoint Hyderabad

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



INFORMATICA POWERCENTER 9.1


1. Power Center Components.

• Power Center Clients

2. Difference between Informatica 8.X and 9.X

3. Power Center Architecture

4. Integration Service Architecture

TRANSFORMATIONS

a). ACTIVE TRANSFORMATIONS.

b). PASSIVE 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.
5). User Defined Functions.
6). Tasks And Types Of Tasks.
7). Worklet and Types Of Worklets.
8). Scheduling Work flow
9). Constraint Based Laod Ordering.
10). Target Load Plan
11). Types Of Batch Processing
12). Link conditions
13). Mapping Parameters
14). Mapping Variables
15). Defining Session Parameters
17). Session Recovery
18). Difference Between Normal and Bulk Loading.
19). Push Down Optimization.
20). PMCMD Utility
21). PMREP Utility
22). Incremental Aggregation
23). TYPES of LookUp Caches.
o Static LookUp Cache
o Dynamic LookUp Cache
o Persistence lookUp Cache
o Shared LookUp Cache
24). Sorter and Rank Cache.
25). ETL UNIT Testing (8 test Cases)
26). ETL PERFORMANCE TESTING (3 test cases)
27). ETL Performance
Optimization techniques
28). Task Implementations.

o Session
o Command
o EMAIL
o Timer
o Event Wait
o Event Raise
o Decision
o Assignment
o Control
o Worklet


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

Drop a mail info@futurepointtech.com we will get in touch with u

Contact seller