DSXchange

:D

Thanks everybody for the help.

Is there any thing i need to do to close this posting?

Now i introduced "Peek" stage like below to the job which actually was working wrong with sort order as descending. Left_Input_file -> Sort stage -> Peek -> Join -> Output Right_Input_file -> Sort stage -> Peek -> To my surprise, it ran fine and gave the expected result. Now i removed the ...

I introduced "Sort stage" before my "Join" stage. Now my "Join" stage has no inlink sort. It just does "Auto" partition. In the "Sort" stage, if I sort in ascending order, it works. In the "Sort" stage, if I sort in descending order, it doe...

Kindly update me if i need to give any further information to make this clear.

There's no reason descending order should not work, provided that you really have specified partitioning and sorting exactly the same for both links, or Entire on the right input (which carries almost ... Thanks a lot. I checked again. I have specified partitioning and sorting exactly the same way....

tagnihotri wrote:Have you sorted both the links in same order ?

Yep.

What I did: I did a Right outer join on two input files using join stage in to a dataset. I partitioned both inputs by "Hash" on key using inlink partition. Observation: When I sort on keys in Ascending order, the stage works fine. When I sort on keys in Descending order, the stage doesn't...