How to get full outer join using join stage
Moderators: chulett, rschirm, roy
How to get full outer join using join stage
Hi,
I want to get full outer join results by using three tables.
first i am trying to get full outer join results using two tables.
In the join stage out put/mapping tab it is showing left record and right record how to mapp this to get full outer join results.
Thanks in Advance!
-Vijay
I want to get full outer join results by using three tables.
first i am trying to get full outer join results using two tables.
In the join stage out put/mapping tab it is showing left record and right record how to mapp this to get full outer join results.
Thanks in Advance!
-Vijay
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
You can full outer join two tables first using a join stage and then pass the output into another join stage for another full outer join.
There should be many other ways if you search the forum.
For left and right record (might be your link names), it doesn't really matter unless you are mapping the required columns to the output.
There should be many other ways if you search the forum.
For left and right record (might be your link names), it doesn't really matter unless you are mapping the required columns to the output.
hi sam here
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
U is one of our posters and is currently working on a server-only project. The second person personal pronoun in English is spelled "you", not "u". And the present tense of the verb "to be" in the second person is spelled "are", not "r".
Please strive for a professional standard of written English on DSXchange. This makes it easier for readers whose first language is not English.
Do you document your actual work using SMS-style abbreviations? Then don't do so here either. DSXchange is not a mobile telephone.
Please strive for a professional standard of written English on DSXchange. This makes it easier for readers whose first language is not English.
Do you document your actual work using SMS-style abbreviations? Then don't do so here either. DSXchange is not a mobile telephone.
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.
I commend on Joining the tables in the sourcing query, which is faster & efficient. If a join stage is used, it will burden Perfomance as there will be more backstage processes running.
To design the job more simpler(visually) & improve performance all the possible logics(Business Rules) are tried to incorporate wihin the Sourcing query, wherever used.
To design the job more simpler(visually) & improve performance all the possible logics(Business Rules) are tried to incorporate wihin the Sourcing query, wherever used.
Two wrongs don't make a right. But three lefts do.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A very simple counter-example is where there is a slow connection to the source database, or where the source database is comparatively very busy compared to the DataStage server.
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: 7
- Joined: Sun Apr 10, 2011 11:30 am
- Location: Delhi
Re: How to get full outer join using join stage
Hi Vijay!
As per my understanding you are struggling at the first join whenever it displayed left record and right record. You can send the both left and right records and put a transformer after the join and write a condition like if the left record is null then populate the right one otherwise left one and then join with the third table and do the same next..
i think it will satisfy your requirements.....
As per my understanding you are struggling at the first join whenever it displayed left record and right record. You can send the both left and right records and put a transformer after the join and write a condition like if the left record is null then populate the right one otherwise left one and then join with the third table and do the same next..
i think it will satisfy your requirements.....