hi friends, I have queries about using join stage.
is it necessary to SORT both links using the keys we want to join?
in parallel job, does the partition wll impact the join result ?
Thanks.
query about join stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Indirectly yes. If you don't specify sorting, then compiling the job will insert sort operators on each input link to the Join stage.
Data should be partitioned on at least the first join key.
Data should be partitioned on at least the first join key.
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.