Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

can we override a native sql query within informatica? Where do we do it?

0 Answers  

---

what is surrogate id ?

3 Answers   IBM,

---

Have you worked with/created Parameter file

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

4 Answers   Magna Infotech,

---

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

What are the new features of informatica 7.1?

2 Answers  

---

Repository user profiles

0 Answers  

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

What is the meaning of up gradation of repository?

0 Answers  

---