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.
Lookup returning null
Moderators: chulett, rschirm, roy
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
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
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
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.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.