GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 77 of 390    Print  
Difference between Hashfile and Sequential File?

  
Total Answers and Comments: 3 Last Update: February 12, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 29, 2005 13:07:29   #1  
malneedi Member Since: September 2005   Contribution: 7    

RE: Difference between Hashfile and Sequential File?
Hash file stores the data based on hash algorithm and on a key value. A sequential file is just a file with no key column. Hash file used as a reference for look up. Sequential file cannot
 
Is this answer useful? Yes | No
August 30, 2007 04:39:13   #2  
Sanj333        

RE: Difference between Hashfile and Sequential File?
Hash file can be stored in DS memory (Buffer) but Sequential file cannot be.. duplicates will be removed in hashfile i.e No duplicates in Hashfile.
 
Is this answer useful? Yes | No
February 12, 2008 04:55:30   #3  
manoharkolukula Member Since: January 2008   Contribution: 32    

RE: Difference between Hashfile and Sequential File?
1. Hashfile can be used as lookup but not the seq file.

2. Hashfile works based on Hashed algorithm.

3. The performence is more in Hashfile when it is used as a ref link(for lkp)

4. we can eliminate duplicates by selecting key value in server jobs.

5. Must and should we have to mention one key in Hashfile.

6. There is a limit of 2GB in Seq file.

.........................

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape