Hash lookup - Values < 1

[nvalia]

Hi,

I have a hash file with one key column data as 0.02, 0.33, 1.06, 2314234.55778,.... and the same data comes from another data source. When I do the look up on the hash file, all rows with this column
values > 1 are matched where as others with value for e.g 0.02 fails even though both have all other key cols matching.
I checked the values in both and they look the same too -- 0.02

Any specific reason for this behaviour?

Thanks,
NV

[Krazykoolrohit]

what is the metadata defined for the key columns? Integer or decimal?

[nvalia]

Decimal 25,7

[ray.wurlod]

Is this when you do a View Data on the hashed file? Can you list the dictionary of the hashed file, at least for the fields in question, and post the results here?