Join two tables

mayura · Post by **mayura** » Fri Jun 11, 2010 6:45 am

Source1-- table1
source2--table2

Table1 and table2 does not have any key column or say joining column.
How to get the data from these two different table into one table.

any

chulett · Post by **chulett** » Fri Jun 11, 2010 6:49 am

What would you do to 'join' these two tables outside of DataStage, say in your favorite SQL tool? Once you determine that, do the same thing in DataStage.

agpt · Post by **agpt** » Fri Jun 11, 2010 9:17 am

you marked this topic as resolved. Can you please tell us what exactly you did?