Page 1 of 1

Join two tables

Posted: Fri Jun 11, 2010 6:45 am
by mayura
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 :idea:

Posted: Fri Jun 11, 2010 6:49 am
by chulett
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.

Posted: Fri Jun 11, 2010 9:17 am
by agpt
you marked this topic as resolved. Can you please tell us what exactly you did?