Multiple choice technology

What is the primary function of the hashed file other than used for lookup/reference?

  1. Duplicates Removal

  2. Arranging the records in order

  3. Grouping the data

  4. Combining Multiple Inputs

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Hashed files use a hashing algorithm on key columns, which naturally eliminates duplicate records because identical keys produce the same hash value and overwrite previous entries. This automatic deduplication is a fundamental property of hash-based storage. The other options describe different DataStage operations not inherent to hashed files.