Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---

What is transformation?

0 Answers  

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

What is the difference between a table and the materialized view?

2 Answers  

---

what is constraint based loading

2 Answers   IBM,

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

---

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

---

explain about informatica server architecture?

1 Answers   IBM,

---