sridhar.gonda

 Profile Answers by sridhar.gonda Questions by sridhar.gonda

• Oct 27th, 2007

 

U hav to create a dummy common column in both tables thn u can join both tables.

vamannam

 Profile Answers by vamannam 

• Apr 12th, 2010

 

The main aim of your question is that you have to load the both table’s data in to your target table with joining of the two tables even if you don’t have a common column to join both tables.

 

My Answer: You have to use Join Transformation with Full Outer Join, and the join condition should be a dummy join (like one column from table one and second column from table two).

 

If you have 10 rows in table one and 5 row in table two. The targets will get loaded 15 rows.

 

Regards,

Vamsi Krishna Mannam