Multiple choice technology

In Datstage server, what are the benefits of using hashed files?

  1. Hashed files are the best way to store data for lookups.

  2. Hashed files are especially useful if they store information with data dictionaries (customer details, countries, exchange rates).

  3. Very fast when looking up the key-value pairs.

  4. All the Above

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

Hashed files in DataStage provide optimized storage and retrieval for reference data. They are ideal for lookups due to their key-based structure, excel at storing relatively static reference data like country codes or exchange rates, and offer very fast lookup performance using hash-based access rather than full table scans.