By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

---

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,

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

What is the command used to run a batch?

0 Answers  

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

What are the different types of schemas?

11 Answers   ITC Infotech,

---

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

what is row level and column level indicator?

1 Answers   TCS,

---