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,

---

In development project what is the process to follow for an etl developer from day1

0 Answers  

---

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

---

What do you mean by filter transformation?

0 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---