Join Stage behaving goofy
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How are the data (a) partitioned and (b) sorted on the inputs to the join stage? Have you made sure, in input link execution order, that the stream input is marked as Left? What style of join are you implementing?
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Good. Now check the Mapping tab (on the Output link) to see from which input each of the output columns is derived. Remember that any column derived from the Right input must be nullable, because a left outer join can return NULL from 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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
And I, blindfolded as it were (I can't see your job) am trying to undertake a systematic diagnostic process. Apart from rushing to post on DSXchange, what diagnostic measures have you taken?
![Mad :x](./images/smilies/icon_mad.gif)
![Mad :x](./images/smilies/icon_mad.gif)
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.