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

4 Answers   CTC,

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

Briefly describe lookup transformation?

0 Answers  

---

What is parallel processing in informatica?

0 Answers  

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

---

What does cheating measurement mean?

0 Answers  

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---