How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

---

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

How we can create indexes after completing the load process?

0 Answers  

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

---