mallikharjuna reddy

• Oct 11th, 2006

 

hi,

  hash file is used to eliminate the duplicate rows based on hash key,and also used for lookups.data stage not allowed to use sequential file as lookup.

yukthi

• Oct 12th, 2006

 

thanx for replying

Prathap Raman

• Oct 16th, 2006

 

Actually the primary use of the hash file is to do a look up. You can use a sequential file for look up but you need to write your own routine to match the columns. Coding time and execution time will be more expensive. But when you generate a hash file the hash file indexes the key by an inbuilt hashing algorithm. so when a look up is made  is much much faster. Also it eliminates the duplicate rows.

jessa

• Oct 24th, 2006

 

these files are stored in the memory hence faster performance than from a sequential file