How do you join the table if there is no relation ship

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

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