product join between two inputs

kishorenvkb · Post by **kishorenvkb** » 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.

kumar_s · Post by **kumar_s** » Thu Apr 24, 2008 4:29 pm

Do you mean to say, Cross product join??
Post it in right forum always.
You can use Join stage to join / merge or lookup. Based on available data.
Add some dummy column say with value '1' in both dataset, and do a lookup on the dummy column.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 24, 2008 4:29 pm

Put a Column Generator on each input to the join stage, in each of which you generate the same constant (a cycle with only one value). Use that as the join key.

Code: Select all

Teradata ----->  ColGen1  ----->
                                  Join  ----->
 Oracle  ----->  ColGen2  ----->

kishorenvkb · Post by **kishorenvkb** » Thu Apr 24, 2008 4:46 pm

Dummy column with the same value worked. Thanks.

Is this not the right forum for this question?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 24, 2008 8:21 pm

That's OK - for new people we understand it can be bewildering (for experienced posters we get a bit more harsh!).

This forum (General) is for when you don't know where to post a question. The moderator may "relocate" this thread to the forum (Enterprise Edition) that is specifically for parallel job questions.

You don't need to do anything with this thread, but please seek out that forum for your future parallel job questions.