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,
Error on hash files
Moderators: chulett, rschirm, roy
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.