Utilization of HASH file

Question

Explain how is the HASH file used and where we can use it?

Answer 1

HASH file is generally used for the Lookup where as the populating fact table keeps the data within the buffer and utilize the Hashing algorithm that improves the performance of the job. It utilizes the GENERAL or SEQ.NUM algorithm.