Answer Posted / iskill tech

Excellant informatica training in chennai adyar - Chennai@iSkill Tech

Free Demo Class avaiable Daily!!

Contact Priya +919894994935

email: iskilltech@gmail.com

Learn INFORMATICA @ i-Skill Tech

• Informatica 8.6

Why i-Skill Tech

Real time Experienced Faculty with more than 5 years of experience working in MNC's like Infosys,IBM,Wipro..
Limited Batch size
Online and corporate training available
Real-time scenario project training
Flexible timing
Weekend batches available for working professionals.
Guidance to Informatica Cetification
100 % job assistance


Branch:
No 3D,Dev appartment,
Opp to Style one,
Above Canara Bank,
Gandhi Nagar,
Adyar



Course contents

Datawarehouse Concepts

1. Data Warehouse Introduction
2. Types of Datawarehouse
1)Enterprise Datawarehouse
2)Datamart
3)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
d) Transformation Developer
e) Mapping Designer
f) Mapplet Designer
g) Task developer
h) Worklet Designer
i) 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
1) SCD Type1
2) SCD Type2 -- Date,Flag and Version
3) SCD Type3

8. Workflow Manger

a) Creating Reusable tasks
b) Workflows, Worklets & Sessions
c) Tasks
1) Session
2) Assignment task
3) Control Task
4) Event raise task
5) Event wait task
6) 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. Differnet Kinds of Load

a) Initial Load
b) Incremental Load


11. Unix Commands and Basics of Unix Shell scripting

12. Project - Case Study

13. Resume Preparation and Assignment











best informatica training center in Chennai, best informatica training center in Chennai Adyar, best informatica

training center , best informatica training, best informatica, best Informatica ,Chennai,GOOD informatica TRAINING IN CHENNAI ADYAR JOB ORIENTED,informatica TRAINING IN CHENNAI ADYAR,informatica TRAINING IN CHENNAI,informatica TRAINING,informatica,Informatica , APPS ,informatica TRAINING IN CHENNAI,informatica TRAINING,CHENNAI,ADYAR,GOOD AND BEST informatica TRAINING IN CHENNAI ADYAR,VERY GOOD informatica TRAINING IN CHENNAI,VERY GOOD informatica TRAINING IN CHENNAI,GOOD AND BEST informatica TRAINING IN CHENNAI PLACEMENT ASSURED,GOOD AND BEST Informatica TRAINING INSTITUTE IN CHENNAI,informatica training in Chennai,informatica training center in Chennai,informatica training institute in Chennai,informatica,11i,10g Chennai,informatica training institute in Chennai,informatica institute in Chennai, best informatica 11i training center in Chennai, best informatica 11i training center in Chennai Adyar, best Informatica
training center , best informatica training, best informatica, best Informatica ,Chennai,GOOD informatica TRAINING IN CHENNAI ADYAR JOB ORIENTED,informatica TRAINING IN CHENNAI ADYAR,informatica TRAINING IN CHENNAI,informatica TRAINING,informatica,Informatica , APPS ,informatica TRAINING IN CHENNAI,informatica TRAINING,CHENNAI,ADYAR,GOOD AND BEST informatica TRAINING IN CHENNAI ADYAR,VERY GOOD informatica TRAINING IN CHENNAI,VERY GOOD informatica TRAINING IN CHENNAI,GOOD AND BEST informatica TRAINING IN CHENNAI PLACEMENT ASSURED,GOOD AND BEST Informatica TRAINING INSTITUTE IN CHENNAI,informatica training in Chennai,informatica training center in Chennai,informatica training institute in Chennai,informatica,11i,10g Chennai,informatica training institute in Chennai,informatica institute in chennai

I studied btech in one of the university but i failed in some subjects so im editing all and trying to apply for ms in USA is there any problem..?? But i have all btech certificates of same college only..

2982

---

do RECRUITERS HAVE ANY CERTIFICATIONS, IF SO WHAT ARE THERE?

2477

---

Sir, I am diploma in electronic engineering student and having five years experience in electrical maintenance including three years in switchgear electrical.... Can I am eligible for electrical supervisor certificate.... Please write me..

1627

---

hi, I have apply twice for visitor visa and I was asked if I have a child and I said no I never knew, but I have seven y (7)year old child . and I plan to reapply for the third time show I tell them that I have a 7 year old child? my child mother and I was loving and later she and her family travel another county were there no communication between , in 2014 they came back and she bought my beautiful duather .

2114

---

why join as medical representative

2198

---

How can we know the certificates are fake or not. I applied the Diploma Certificates from Bhihar State Board of Technical Education and Trainning but now i am getting some dought about this Certificates. so please tell me is their any site to know the Certificates Fake or Orginal

5908

---

what is an added benefit for using vortex pumps?

1852

---

can someone send me which is the best sas training institute in chennai?

1904

---

Hello, This is Ritesh , having 4 year exp of Manual testing and 2 exp in CMMi. I can create Test cases and all activities which includes in manual testing. I know C language and can programm it. I have done all cmmi knowldge now I need to know the details like which certification I need to do if I want to do career in Software Process imrovment plz suggest me if there are placement also with certification. regards,

2067

---

hi i done IBM AS/400 course .....i want to certification any one can information about that and material of soft copy for that....please its urgent

2125

---

Hi I want to do certification on security trading.Any idea ?

1952

---

I have 2 yrs ex in informatica and i am planning to do the certification. Can you please send me all the details on mcaprasad24@gmail.com thanks

2351

---

Can anyone pls let me knnow is there any change in dump recently(in 2011 ) for IBM EXAM703 ?

2037

---

Fill in the blanks to acheive false as output of the third line float varA =_____; float varB = varA; System.out.println(varA == varB);

3173

---

PMP certification. Please call 9866654045

2267

---