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,

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

How to load data in informatica ?

0 Answers  

---

performance tuning of Informatica

1 Answers  

---

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

How do you take back up of repository?

0 Answers  

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

what transformations are used for Variable port?

2 Answers  

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---