Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - Why we use hash file for lookup?

asked mar September 20, 2014 06:31 AM  

Why we use hash file for lookup?


1 Answers

answered By vishnoiprem   0  
  • Mainly hased files are used for lookup perpose. for example your looking for the data whether the entry is their or not. if it is thr do something otherwise something else
  • Hashed file is used for lookup process. Beside that, Hashed file can also be used if we want to get Distinct data from a source by using the column as key. Sample, I want to get list of country from Customer records. One possible solution is I create a Hashed file and using Country as its key. Then I can get distinct value of Country.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!