why we use hash file for lookup?

Answer Posted / bharath

Hash file is a refference table based on key fileds which
can provide fast access in lookups. Just to spped up the
lookup process we use hash files.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use link partitioner and link collector in datastage?

784


What are the repository tables in datastage?

927


What is "fatal error/rdbms code 3996" error?

767


What is the command line function to import and export the ds jobs?

780


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

751






How to implement complex jobs in data stage?

742


What is a ds designer?

739


Name the third party tools that can be used in datastage?

715


What are the different options associated with dsjob command?

1082


Why fact table is in normal form?

771


What is job control?

714


How to reverse the string using SQL?

984


What is the difference between an operational datastage and a data warehouse?

734


What are stage variables, derivations and constants?

768


Explain the importance of surrogate key in data warehousing?

821