Price: 12000.00 ₹

Description

Informatica Training Center in Chennai / Greens Technology Adyar 

Website:http://www.greenstechnologys.com/ 
Email id: greens.adyar@gmail.com 
Contact 9940516384 / 9840496320

Greens Technology Chennai is situated in the heart of the city is it at Adyar with expert team of dedicated trainer. They are all catalyst for your success both in life and in the supplementary course. They will make you to understand the course content in befitting manner. The institute situated in spacious building is amenities having internet facilities computers. 

The trainers will train the trainees according to the needs of the MNC and they will guide in the placement. 
The institute is fully functional one with all amenities and high performances. 

It is your turn to keep your social and future life at your fingers tips with Greens Technology Adyar. 

So according this you may prepare the resume with particular course specifications 

Datawarehouse Concepts 
1. Data Warehouse Introduction 
2. Types of Datawarehouse 
a. Enterprise Datawarehouse 
b. Datamart 
c. Operational Data Store 
3. OLAP VS OLTP 
4. Data Warehouse Architecture 
5. Dimensional Modeling 
6. Star Schema 
7. Snowflake Schema 
8. MultiStar Schema 
9. Fact 
10. Dimension 
11. Slowly Changing Dimension 
12. Confirmed Dimension 
13. Junk Dimension 
14. Change Data capture 

E T L Informatica Power Center 8.6.x & 9.0.x 
1. Power Center Components 
a. Designer 
b. Repository Manager 
c. Workflow Manager 
d. Workflow Monitor 
e. PowerCenter Admin Console 

2. Repository Administration 
a. Creating Repository Users and Groups . 
b. Connecting to the Repository. 
c. Creating a Group 
d. Assigning Privileges to a Group. 
e. Creating a User 
f. Creating a Folder 
g. Folder Permissions 
h. Creating Folders 


3. Informatica Concepts and Overview 
a. Informatica Architecture. 
b. Informatica(Introduction) 
c. Source Analyzer 
d. Target Designer 
e. Transformation Developer 
f. Mapping Designer 
g. Mapplet Designer 
h. Task developer 
i. Worklet Designer 
j. Workflow Designer 

4. Sources 
a. Working with relational Sources 
b. Working with Flat Files 

5. Targets 
a. Working with Relational Targets 
b. Working with Flat file Targets 

6. Transformations - Active and Passive Transformations 
a. Expression 
b. Lookup --Different types of lookup Caches 
c. Sequence Generator 
d. Filter 
e. Joiner 
f. Sorter 
g. Rank 
h. Router 
i. Aggregator 
j. Source Qualifer 
k. Update Strategy 
l. Normalizer 
m. Union Transformation 
n. SQL Transformation 
o. Debugging Mappings 

7. Mappings & Mapplets 
a. Mapping Variables & Parameters 
b. Creating Mapping, Mapplet and reusable transformation 
c. Working with Mapping Wizards 
d. Slowly Changing Dimension 
i. SCD Type1 
ii. SCD Type2 -- Date, Flag and Version 
iii. SCD Type3 

8. Workflow Manger 
a. Creating Reusable tasks 
b. Workflows, Worklets & Sessions 
c. Tasks 
i. Session 
ii. Assignment task 
iii. Control Task 
iv. Event raise task 
v. Event wait task 
vi. Timer task 
d. Monitoring workflows and debugging errors 
e. Post session and Pre-session commands 
f. Session recovery 
g. Commit points 

9. Performance Tuning 
a. Informatica Tuning (Source, target, mapping & Session) 
b. Informatica Pushdown optimization and pipeline partition 
c. Incremental aggregation

10. Different kinds of Load 
a. Initial Load 
b. Incremental Load 

More Details

Total Views:10
Reference Id:#134790
Phone Number:9940516384
Website URL:Click To Visit
Current Rating: 5.0/5 1 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com