how to do full outer join
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
how to do full outer join
HiAll,
I have one sequential file and one hash file as sources, how to do full outer join of these with out using oracle or oci stage in server jobs.
Thanks
Malli
I have one sequential file and one hash file as sources, how to do full outer join of these with out using oracle or oci stage in server jobs.
Thanks
Malli
MALLI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A full outer join is not possible if a hashed file is involved as one of the sources. Run the hashed file into a sequential file. Then, in a separate job, use a Merge stage to form the full outer join of the two sequential files.
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: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
Re: how to do full outer join
can we use merge stage in server jobs?i never used merge stage in server jobs,that's why i am asking this question.
MALLI
Re: how to do full outer join
Yes. but do not confuse server merge stage with px merge stage. They are different.mallikharjuna wrote:can we use merge stage in server jobs?i never used merge stage in server jobs,that's why i am asking this question.
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
Re: how to do full outer join
i tried with merge stage in server jobs,but this stage not allowing to giving input links to merge stage.
MALLI
Re: how to do full outer join
It will not accept input links. You can specify the details about the two sequential files within the merge stage. Read the documentation for furthur details.mallikharjuna wrote:i tried with merge stage in server jobs,but this stage not allowing to giving input links to merge stage.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That's why you need two separate jobs. The Merge stage (server jobs) reads two sequential files directly (it does not support input links) and forms a join between them based on criteria that you specify.
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.
Re: how to do full outer join
good question, i agree with ray, merge stage will definitely help for outer join.
Re: how to do full outer join
hi ray i have a question like what if full outer join has lot of data, say suppose in GB, will merge hamper the performance.
For even greater flexibility you can put data into a hash file or files and then write a pre- or post-transform routine to open the file(s) and merge the data, if necessary into a completely different field (column) format! Just make sure you have sensible key fields.
_______________________________________
"If I had asked people what they wanted they would have said faster horses"
Henry Ford
"If I had asked people what they wanted they would have said faster horses"
Henry Ford