Answer / lisa

I can add one dummy column to both the tables with value '1' and join both the tables on the basis of that dummy column. But how to do the join when there are huge number of columns/huge data volume in the tables? Please reply!

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

Which will beter perform IIf or decode?

3 Answers   TCS,

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---

What is repository manager?

0 Answers  

---

What does refresh system mean, and what are its distinctive choice?

0 Answers  

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  

---

Explain what transformation and how many are there in informatica?

0 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,

---