DSXchange

Hi Team,

I am using a Join stage to do perform a lookup based on 3 columns.
Left Outer Join is used. I am not getting look up values.

I replaced Join stage with LOOKUP stage, to my surprise I am getting matches.

No other changes were done in the job, for datatypes or Columns names.
Just a change in stage.

Any specific settings need to be changed for Join stage ?

Verify that the inputs to your join stage are properly partitioned and sorted (usually by all of your join keys) and that you have the proper input link order. Either mistake could result in a silent failure.

Mike