DSXchange

Hi all,

I have a lookup and supposed to get one column from reference link but this is returning null values despite of having matched keys. Any idea why it might be happening? All the column metadata is same on matched keys.

The obvious answer is that they do not actually match.

Are you sure that there are no hidden characters in either source that would cause a mismatch (eg nulls, line feeds, spaces)?

yes 100% sure

The only other thought is that its down to partitioning, and that your records are actually on 2 different partitions hence no match.

If the partitioning is correct then usually at this point I would start performing checks like
* outputting the lengths of the values in the input columns you are trying to compare (this can help show up hidden characters)
* depending on your source - trying to view the data in hex/ascii/binary to see that they are identical

Did you change lookup reference partitioning from default to any other type of partioning?

Is it same as partitioning in the stream link and is it a key based partitioning that you have selected?

easiest way to check if the problem is related to partitioning, change partitioning in reference link to entire and then run the job. If you still don't get the key matched, it should be data issue like some non printable characters.