i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

What is a rank transform?

0 Answers  

---

What is the format of informatica objects in a repository?

0 Answers  

---

How to enter same record twice in the target table,explain?

7 Answers  

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

what is size of u r database?

0 Answers  

---