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.
product join between two inputs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54
- Joined: Mon Dec 24, 2007 9:27 am
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.
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 ----->
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54
- Joined: Mon Dec 24, 2007 9:27 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.