DSXchange

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.

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.