Answer Posted / nagendra

Can you please mail me a copy of Informatica Certification
Exam dumps to gajula.nagendra@gmail.com

How etl testing is different from database testing?

1121

---

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1860

---

How to fine tune mappings?

997

---

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2226

---

What is initial load and what is full load?

1050

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2328

---

Give the benefits of data integration suite?

955

---

What is abap? What are idocs?

1020

---

How many steps etl contains?

992

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2082

---

Identifying the bottlenecks in various components of Informatica and resolving them.

1981

---

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

2120

---

what is an ETL or ETT? And what are the different types?

7560

---

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

2045

---

what are the concerns of OLTP and DSS systems?

2504

---