Lookup returning null

BSG1 · Post by **BSG1** » Tue Jun 09, 2015 9:10 am

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.

ShaneMuir · Post by **ShaneMuir** » Tue Jun 09, 2015 9:20 am

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)?

BSG1 · Post by **BSG1** » Tue Jun 09, 2015 9:21 am

yes 100% sure

ShaneMuir · Post by **ShaneMuir** » Tue Jun 09, 2015 9:33 am

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

priyadarshikunal · Post by **priyadarshikunal** » Wed Jun 10, 2015 2:15 am

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.