Page 1 of 1

Hash Files

Posted: Fri May 20, 2005 10:29 am
by reddy
Hello sir,

How to make hash files reusable means i am created one hash file it can be used by other developers also,please provide me steps.

Thanks in advance.

Thanks
Narasa

Posted: Fri May 20, 2005 10:37 am
by ArndW
A hash file is just like a database/table - if different developer point to the same file they will share it's contents; and by importing the column metadata into manager and using that definition it's description can also be shared.

Posted: Fri May 20, 2005 11:05 am
by reddy
ArndW wrote:A hash file is just like a database/table - if different developer point to the same file they will share it's contents; and by importing the column metadata into manager and using that definition it's description can also be shared.

Arndw,

I created a hashfile with Account named as sales but some body wants to use my hash file that i was created,please help me out ...

Thanks
Narasa

Posted: Fri May 20, 2005 11:20 am
by ArndW
The other person should use the same Account & Hash file names in their job design as well and both of you will be using the same physical file.

Posted: Fri May 20, 2005 11:56 am
by chulett
As long as 'using' means 'reading from'. :wink:

Posted: Fri May 20, 2005 12:08 pm
by ArndW
Craig - or "both of you can then overwrite each other's records in the same hash file" ;) The caveat should always be there when you have someone else using your data - sometimes data can mysteriously disappear or get modified.

Posted: Fri May 20, 2005 2:11 pm
by bryan
Why cant he just enable hash file cache sharing in job properties provided the operations by the two developers are read-only?

Posted: Fri May 20, 2005 6:00 pm
by ray.wurlod
You don't need hashed file cache sharing unless both users are using cache. It is sufficient that both users refer to the hashed file in the same way - that is, same location (whether account or pathname) and same name (correctly spelled and cased).

And, as others pointed out, all writes to hashed files are destructive overwrites. You carry the risk.