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

4 Answers   CTC,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

---

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

---

What are two types of processes that informatica runs the session?

2 Answers  

---

Why union transformation is an active transformation?

0 Answers   Informatica,

---

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---