product join between two inputs
Posted: Thu Apr 24, 2008 4:13 pm
Hello,
I have few columns coming from one oracle stage and few other columns coming from another teradata stage.
How can I do the product join between these two and what stage should I be using for this?
There are no common columns between these two sources.
I mean from Oracle instance I have columns A and B.
From Teradata instance I have columns C, D and E.
The desired output is A, B, C, D, E with a product join between the two.
Please assist.
I have few columns coming from one oracle stage and few other columns coming from another teradata stage.
How can I do the product join between these two and what stage should I be using for this?
There are no common columns between these two sources.
I mean from Oracle instance I have columns A and B.
From Teradata instance I have columns C, D and E.
The desired output is A, B, C, D, E with a product join between the two.
Please assist.