Error on hash files

boligoma · Post by **boligoma** » Thu Jun 14, 2007 11:23 am

Hi,

I'm trying to use two hashed files in a transformer job. Hash File 1 (the main row operation) has exactly the keys as Hash File 2. In fact, I created Hash File 2 from Hash File 1 in another job.

The only difference I see is that Hash File 1 is downloaded in an Oracle Table. I made a group by and a operation and put it again in a Hash File (hash file 2).

There are no results coming from Hash File 2, although it has the same keys, I even tried to put one single row that appears in both files and there is no information returned. The definition on both jobs is OK.

Please help,

Thanks,

DSguru2B · Post by **DSguru2B** » Thu Jun 14, 2007 12:50 pm

Make sure your keys are trimmed, both for the source and lookup.

boligoma · Post by **boligoma** » Thu Jun 14, 2007 1:36 pm

Hi, what do you mean by trimmed?

DSguru2B · Post by **DSguru2B** » Thu Jun 14, 2007 1:38 pm

Apply Trim() function on the keys. Because 'ABC' <> 'ABC '.
ANother possiblity might be that you are doing a group by operation, is there any chance of transforming a column that is being used as a key in the hashed file? If any single key is different, the lookup will fail.

gateleys · Post by **gateleys** » Thu Jun 14, 2007 2:13 pm

boligoma wrote:Hi, what do you mean by trimmed?

In your designer, click on Help menu, and search for TRIM.

gateleys

boligoma · Post by **boligoma** » Thu Jun 14, 2007 3:35 pm

Thanks for the advice, I trimmed (never used it as a verb before) all the joins and the group by function in oracle and it worked fine. I thought it was an issue about a corrupt file or something like that...