What is the Difference between Hashfile and Sequential File

Sourav · Post by **Sourav** » Sat Oct 31, 2009 3:23 am

Difference between Hashfile and Sequential File

ArndW · Post by **ArndW** » Sat Oct 31, 2009 6:10 am

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.

ray.wurlod · Post by **ray.wurlod** » Sat Oct 31, 2009 8:40 pm

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.