Issue with Lookup

aladap12 · Post by **aladap12** » Tue Aug 18, 2009 8:04 am

Friends,

I have an Issue at my work.
The Issue is, I have a big text file which is Pipe delimer on it. I am trying to read that file in colunms
1.NO(decimal) 9 and 2.Remdata(varchar) 9999999
and I am writing in Hash file for lookup purpose with yesterdays file.

Here i am getting problem, Lookup is not perfromed as we desired.
No records from lookup file are not coming out properly,
can you guys suggest me how to achive good results.

Thanks
VKR

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Aug 18, 2009 8:26 am

Try to pass values which you are sure are present in lookups.

Did you check the format of data loaded?

Did you test in a stand-alone mode?

Provide sample values.

chulett · Post by **chulett** » Tue Aug 18, 2009 8:34 am

You've given us no clues about your hashed file design - which are the key field(s) you are looking up on? Basically you need to ensure the values used to build the hashed file are identical to the values used in the lookup key expression or the lookup will fail. And "identical" means identical - type, case, length, trimming, etc - everything must match 100%.