Hashed File stage Lookup propertry in server job

swapna07 · Post by **swapna07** » Tue May 21, 2013 5:20 am

Hi, I am new to this forum...don't know whether am posting to the correct link or not...am preparing a document to show the usefulness of Hashed file stage in server jobs.Below is the scenario..

I have one input ODBC enterprise stage with one table and other referential ODBC enterprise stage with another table both going as input link to hashed file stage which is doing lookup based on the two common key present in both the table...one output link is going from hashed file stage to sequential file. compilation is successful but when i run the job, it is saying "Unable to Open the file path name" which i have given in seq file and as output file path in hashed stage. although i checked the parameter set and the path. But don't know how to go about it... can please anyone help me on this ?

chulett · Post by **chulett** » Tue May 21, 2013 6:24 am

swapna07 wrote:Hi, I am new to this forum...don't know whether am posting to the correct link or not

Welcome. And... you're not.

You needed to start a new post but instead you replied to an old one. I've split this out for you so now we're better but I had to guess on your O/S and version. Please let me know if either is incorrect.

chulett · Post by **chulett** » Tue May 21, 2013 6:27 am

So this really has nothing to do with a hashed file lookup per se? But rather an error when attempting to write to a Sequential file? Sounds like your output file path is either invalid or your running user doesn't have permissions to write to it.

ray.wurlod · Post by **ray.wurlod** » Tue May 21, 2013 2:40 pm

To do a lookup against a hashed file there must be a reference link from the Hashed File stage to a Transformer stage. A link from a Hashed File stage to a Sequential File stage is a stream query from the hashed file.

chulett · Post by **chulett** » Tue May 21, 2013 2:45 pm

By chance could you post an "ascii art" picture of the stages in your job? So we are certain how the data is flowing from source to target. Wrap it in

Code: Select all

 tags to preserve any whitespace... and make liberal use of the 'Preview' button to make it looks fine after posting.

swapna07 · Post by **swapna07** » Sat May 25, 2013 7:27 am

ok. i will post my job screen capture here so that u guys can get a clear picture of what am trying to say.thanks.

swapna07 · Post by **swapna07** » Mon Jun 03, 2013 4:31 am

Hey can anyone tell me how to use hashed file stage as a lookUp stage reading records from two SQL tables through ODBC stage and writing it into sequential file. Please help.

chulett · Post by **chulett** » Mon Jun 03, 2013 6:12 am

Again, post something that shows us what you are trying to accomplish. Either take a screen capture of the job's canvas, load it up to any of the free file hosting sites and then use [img] tags to include it in a post here or simply "draw" it using text as I noted in my "ascii art" post.

I'm sure you're not having an issue sourcing from ODBC and since you are writing a paper on "the usefulness of hashed files" to me that implies a knowledge of using them. Seems to me the sticky part is the role the sequential file is playing here and that's still unclear from your descriptions. I could guess but I'd rather see your job design...

ray.wurlod · Post by **ray.wurlod** » Mon Jun 03, 2013 2:06 pm

Hashed File stage can not "look up ... reading from ... SQL tables".

A Transformer stage performs a lookup from a Hashed File stage. The Hashed File may have been pre-loaded with content from the table.

DSXchange

Hashed File stage Lookup propertry in server job

Hashed File stage Lookup propertry in server job

Re: DataStage Hashed File stage LookUp propertry in server j