what are two types of hash files??how it differ?
Posted: Sun Nov 19, 2006 1:48 am
Hi,
.Let me know ,what are two types of hash files??how it differ?
thanks.
.Let me know ,what are two types of hash files??how it differ?
thanks.
A short text to describe your forum
http://dsxchange.com./
While true, the important aspect of static hashed files is not the algorithm used to turn the key into a number (the hashing method) but the number of buckets, or modulo, that is specified when defining the file. This remains static, unlike the type 30 defined below. Thus a file can take up hundreds of megabytes on disk yet have no records, or can have a modulo of 1 with millions of records and take minutes or hours to read just 1 row.rameshrr3 wrote:Types 2 through 18 are static hashed files
each based on the hashing algorithm / nature of key column data
Type 30 uses either a sequential numeric or general type of hashing algorithm, defaulting to general and will dynamically increase or decrease the modulo of the file depending upon it's size and use of space.rameshrr3 wrote:Type 30 Dynamic hashed file, where system decides whats best.
No type 27. Distributed and Partitioned files use quite different mechanisms to define their access and/or actual paths. The part files are datastage hashed files themselves.rameshrr3 wrote:Type 27( Distributed or partitioned??)
Type 25 is a hashed file; it is a balanced B-Tree file.rameshrr3 wrote:Type 25 is made available in the hashed file stage icon .
No, types 1 and 19 are not native files, they are directories. Type 1 is for older OSs which have a limitation on the length of path components. I think it uses 16 characters but am no longer certain. So writing "This_Is_A_Long_Record_Name" would actually get written to a subdirectory path called "This_Is_A_Long_R/ecord_Name". Type 19 is for long path names.rameshrr3 wrote:Type 1,Type 19 (engine native files)