DSXchange

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,

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

Hi, what do you mean by trimmed?

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.

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

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

gateleys

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...