malneedi

 Profile Answers by malneedi 

• Sep 29th, 2005

 

Hash file stores the data based on hash algorithm and on a key value. A sequential file is just a file with no key column. Hash file used as a reference for look up. Sequential file cannot

Sanj333

• Aug 30th, 2007

 

Hash file can be stored in DS memory (Buffer) but Sequential file cannot be.. duplicates will be removed in hashfile i.e, No duplicates in Hashfile.

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Feb 12th, 2008

 

1. Hashfile can be used as lookup but not the seq file.

2. Hashfile works based on Hashed algorithm.

3. The performence is more in Hashfile when it is used as a ref link(for lkp)

4. we can eliminate duplicates by selecting key value in server jobs.

5. Must and should we have to mention one key in Hashfile.

6. There is a limit of 2GB in Seq file.
 
.........................