How to read hash file from parallel job

G.K.K · Post by **G.K.K** » Tue Mar 23, 2010 4:01 am

Hi,

I am migrating some server jobs to parallel jobs.
I have a below scenario :
I have a server job which creates hash file, i want to use this hash file in parallel job as a source/lookup. which parallel stage reads the hash file created by server?

Please advise me to get out of this hurdle.

Thanks in Advance
K.K

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Mar 23, 2010 4:10 am

There is no pre-built parallel stage that can read hashed files.

You can either use server activities or convert the hashed file into a dataset or similar.

G.K.K · Post by **G.K.K** » Tue Mar 23, 2010 4:27 am

Sainath.Srinivasan wrote:There is no pre-built parallel stage that can read hashed files.

You can either use server activities or convert the hashed file into a dataset or similar. ...

Thanks for your reply,
How we can achieve hash file functionality in parallel jobs?

Thanks in Advance
G.K.K

ArndW · Post by **ArndW** » Tue Mar 23, 2010 4:44 am

You could use database tables or re-engineer your processes to use datasets.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 23, 2010 4:06 pm

G.K.K wrote:How we can achieve hash file functionality in parallel jobs?

May I ask why you feel it is necessary to do this?

You may be able to use ODBC, with the localuv data source, or you may be able to use an External Source stage invoking dssh with an appropriate query on its command line. I am not in a position to be able to test either of these at the moment.