I need to join three files together to get the desired file. currently i am doing this by doing a join twice like
File B File C
| |
| |
File A ---> Join-----> Join ---->Output File
both the joins are Left Outer. I need some fields from each file.
While going through the documentation of DataStage PX I read about the Intermediate Links and tried to use them. but the problem that i faced was that only those fields from input can be used to derive output file's fields, which are keys.
However this is not the case in my job. i have to derive several output file fields from input file fields which are not part of the key.
How an i use intermediate links in join stage. Is there any way i can use a single join stage to do this or i will have to stick with multiple joins.
Thanks in Advance
P.S. Data is very huge and Lookup stage cant be used.
Inermediate link in join stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Tue Jul 13, 2004 7:40 am
Re: Inermediate link in join stage
Hi
I have used 14 files to join using intermediate Links and it works fine. I too used a left outer join and derived not only the key columns but other columns from each of the input files as well. However, my left most file is the master file that contains two key columns and all other files contain these two common key fields .
Hope that replies your question whether you can use a single join or not.
By the way I donot see any disadvantage using cascading join too since you need to join three files only.
Thanks,
Somesh
I have used 14 files to join using intermediate Links and it works fine. I too used a left outer join and derived not only the key columns but other columns from each of the input files as well. However, my left most file is the master file that contains two key columns and all other files contain these two common key fields .
Hope that replies your question whether you can use a single join or not.
By the way I donot see any disadvantage using cascading join too since you need to join three files only.
Thanks,
Somesh
Re: Inermediate link in join stage
How these 14 files are brought to the join stage: after two links are added as left and right links, more links are added to the stage and will be treated as Intermediate links without any issue?
Thanks,
Thanks,
Re: Inermediate link in join stage
I Guess you can use merge stage also, don't you?
Re: Inermediate link in join stage
Can any one tell what the intermediate links are different with left and right links? For the types of join: inner, left / right outer and full, are they not applied to these intermediate links?
thanks,
thanks,
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage does it the same way database servers do it: pairwise from the left. So, if you have three inputs for example, the left and intermediate inputs are joined then the result of that is joined with the right input.
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.