DataStage Range Lookup Failure – What Gives?

I just spent the majority of my morning trying to figure out why in the world my range lookup kept failing.  Hopefully this will save you some time in troubleshooting your range lookup failures.  To cut right to the chase, my resolution involved sorting my reference source prior to doing the lookup.  Adding a sort stage with the appropriate sort keys prior to doing the lookup solved my problem.  I probably learned this in a training at some point, but I just didn’t retain it....

Submit