I am slightly puzzled with the datastage full outer join. I have Key fields and values. the full outer join drops off common fiels (other than the key fields , or join fields).
Can anyone tell me on what basis it drops the records.
Shouldn't it be the other way i.e. dropping common key fields and retaining other fields from both inputs.
full outer join
Moderators: chulett, rschirm, roy
The full outer join will combine table contents, never drop rows. See http://en.wikipedia.org/wiki/Join_(SQL)#Full_outer_join for a good description of the join functionality.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It drops common key fields because they are identically valued and identically named. You can avoid this by using different naming conventions on the two inputs. A Copy stage is the most efficient stage for simply renaming columns.
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.