Check with seller Informatica Online Training at Futurepointtech Hyderabad
- Location: Hyderabad, Hyderabad, telangana, India
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.
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.
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.
http://www.futurepointtech.com/informatica-training.html
Drop a mail info@futurepointtech.com we will get in touch with u
Useful information
- Avoid scams by acting locally or paying with PayPal
- Never pay with Western Union, Moneygram or other anonymous payment services
- Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
- This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"
Related listings
-
Get Trained at an International Fashion Hub with HamstechOther Classes - Hyderabad (Telangana) - October 5, 2019 1.00 Indian ₹
Hamstech’s 18-Month Fashion Design course comes with a huge scope for great skill building and career prospects! Here’s why: ❏ 3-week study programme in Singapore, a fashion hub in Asia. ❏ Mentorship of 4-time National Award winning, internationally ...
-
Build Your Skills and be a Pro in Photography with HamstechOther Classes - hyderabad (telangana) - September 30, 2019 1.00 Indian ₹
Do you know that Photography is one of the most creative and promising careers today? If you have an eye for detail and the ability to get the perfectly-timed frames, then you should join Hamstech’s Photography course. Here is why: ❏ Mentorship of on...
-
Interior Design Training by Industry Experts. Join Hamstech!Other Classes - hyderabad (telangana) - September 20, 2019 1.00 Indian ₹
Here is an opportunity to be a creative professional through an innovative and dynamic learning programme! Join Hamstech to experience the quality and explore the prospects of well-planned creative education programmes. Can you imagine yourself desig...