Page 1 of 1
What is the Difference between Hashfile and Sequential File
Posted: Sat Oct 31, 2009 3:23 am
by Sourav
Difference between Hashfile and Sequential File
Posted: Sat Oct 31, 2009 6:10 am
by ArndW
Parallel jobs do not have hashed files, only server jobs do. Hashed files are similar to database tables and one can do indexed or keyed reads on them, as well as update the contents; this cannot be done with sequential files.
Posted: Sat Oct 31, 2009 8:40 pm
by ray.wurlod
When's the interview?
There is no such thing as a hash file, other than a tool for shaping a block of hash.
The correct terminology in DataStage is "hashed" file. It is so called because it uses a hashing algorithm, rather than a primary key index or other mechanism, to determine the unique location of each record within its structure.