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

2 Answers  

---

What is etl process. How many steps etl contains explain with example?

0 Answers  

---

what is session partitioning?

1 Answers  

---

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

0 Answers   Cap Gemini,

---

List few etl bugs?

0 Answers  

---

what are Lookup caches options? Including persistent caches.

0 Answers  

---

What are the differences between sql override and update override?

0 Answers  

---

how do u really know that paging to disk is happening while u are using a lookup transform?

0 Answers  

---

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.

0 Answers  

---

what is the advantage of persistent cache? when it should be used?

2 Answers  

---

Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,

---

How to fine tune mappings?

0 Answers  

---