DSXchange

Hi,

I have designed two job which fetches data from external database to sequential files.

In another job i have used those two sequential file.

one as source and another one as reference, i have used like sequential file to hash file then to transformer in reference side , and source to transfomer i am performing look up on a key column, the problem is i find the look up match dont happens but there are matching records .

I tried to hardcode the value in source side with a value which is available in the reference hash file still there is no match.

Please Help me.

Typically that would be a trimming problem, one or both sides have extra spaces so "XXX" doesn't match to "XXX ", for example. Triple-check that that's not the case.