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

DataStage - Why we use hash file for lookup?




673
views
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.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


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!

Alert