Page 1 of 1
Usage of Hashed File Stage
Posted: Sat Sep 14, 2013 10:25 pm
by IBMDS4KK
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 ?
Posted: Sun Sep 15, 2013 5:08 am
by ArndW
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.
Posted: Sun Sep 15, 2013 7:42 am
by chulett
Typically used for lookups. If you have any Informatica experience, I can make a comparison if that would help.
Posted: Tue Sep 17, 2013 11:03 pm
by IBMDS4KK
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.
Posted: Wed Sep 18, 2013 1:40 am
by ArndW
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.
Posted: Wed Sep 18, 2013 6:48 am
by IBMDS4KK
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.
Posted: Wed Sep 18, 2013 7:18 am
by chulett
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?
Posted: Wed Sep 18, 2013 8:32 am
by ArndW
If the hashed file exists and has data, then please post the exact error message, as the view-data functionality should work.
Posted: Thu Sep 19, 2013 6:07 am
by ray.wurlod
Report to us all the property settings in the Hashed File stage. Beware, too, that names are case sensitive.
Posted: Mon Sep 23, 2013 4:08 am
by arunkumarmm
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.
Posted: Mon Oct 21, 2013 12:03 pm
by oracledba
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