GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage

 Print  |  
Question:  What are Static Hash files and Dynamic Hash files?

Answer: As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size.


May 05, 2006 05:00:11 #1
 Alfons   Member Since: May 2006    Total Comments: 2 

RE: What are Static Hash files and Dynamic Hash files?...
 

Hello,

The hashed files have the default size established by their modulus and separation when you create them, and this can be static or dynamic.

Overflow space is only used when data grows over the reserved size for someone of the groups (sectors) within the file. There are many groups as the specified by the modulus.

     

 

Back To Question