Usage of Hashed File Stage

IBMDS4KK · Post by **IBMDS4KK** » Sat Sep 14, 2013 10:25 pm

Hi All,

I am new to server jobs. And currently my project is support project. While analyzing the job, I was not able to understand what is use of Hashed file stage and the main concept behind this ?

ArndW · Post by **ArndW** » Sun Sep 15, 2013 5:08 am

Hashed files in server jobs are similar to very fast local tables used to store and retrieve data. Perhaps the Manual Pages might help you further.

chulett · Post by **chulett** » Sun Sep 15, 2013 7:42 am

Typically used for lookups. If you have any Informatica experience, I can make a comparison if that would help.

IBMDS4KK · Post by **IBMDS4KK** » Tue Sep 17, 2013 11:03 pm

Dear Craig,

1) Are we able to view the data of hashed file ?

2) In my project, some hashed file stages are used as a reference to the Transformer stage. I wanna see the data of hashed file, for that I was asked my team mates what is the source of the hashed file. But no body responded. Could you suggest how to see the data ?

Note: I do not have Informatica Experience.

ArndW · Post by **ArndW** » Wed Sep 18, 2013 1:40 am

You can do a "view data" by right-mouse-clicking on a hashed file in the designer, this is the easiest option for you. The other option is to enter TCL and issue either the old UniVerse DML or SQL commands to list the file, but I'd recommend sticking with "view data" for the moment.

IBMDS4KK · Post by **IBMDS4KK** » Wed Sep 18, 2013 6:48 am

Dear ArndW,

The option which you mentioned 'Right Click' on the stage is not working, When i do this it will display like unable to open the file. Please suggest something else.

chulett · Post by **chulett** » Wed Sep 18, 2013 7:18 am

If the job has never been run and thus the table never created and populated, then you'll get that error. Is that the case?

ArndW · Post by **ArndW** » Wed Sep 18, 2013 8:32 am

If the hashed file exists and has data, then please post the exact error message, as the view-data functionality should work.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 19, 2013 6:07 am

Report to us all the property settings in the Hashed File stage. Beware, too, that names are case sensitive.

arunkumarmm · Post by **arunkumarmm** » Mon Sep 23, 2013 4:08 am

Check for the proper file name too.

If the file name is parametrized, it might not have the same file name/path in the job as it does in the job sequence.

You may need to verify those values before trying to view it.

oracledba · Post by **oracledba** » Mon Oct 21, 2013 12:03 pm

IBMDS4KK wrote:The option which you mentioned 'Right Click' on the stage is not working, When i do this it will display like unable to open the file.

Dont right click..... Double click on hash file stage. go to output tab. click on view data