Hi,
.Let me know ,what are two types of hash files??how it differ?
thanks.
what are two types of hash files??how it differ?
Moderators: chulett, rschirm, roy
This sounds far too much like an interview question to go into detail answering!
DSXchange has a powerful search facility which would have pointed you to Ken Bland's tech tip on hashed files or this post amongst hundreds of other hashed file related posts.
DSXchange has a powerful search facility which would have pointed you to Ken Bland's tech tip on hashed files or this post amongst hundreds of other hashed file related posts.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Types 2 through 18 are static hashed files
each based on the hashing algorithm / nature of key column data
Type 30 Dynamic hashed file, where system decides whats best.
And you have non hashed files
Type 1,Type 19 (engine native files)
Type 25(Balanced Tree)
Type 27( Distributed or partitioned??
)
Type 25 is made available in the hashed file stage icon .
Thats my 2 cents for this one.
When is the interview
![Wink :wink:](./images/smilies/icon_wink.gif)
each based on the hashing algorithm / nature of key column data
Type 30 Dynamic hashed file, where system decides whats best.
And you have non hashed files
Type 1,Type 19 (engine native files)
Type 25(Balanced Tree)
Type 27( Distributed or partitioned??
![Confused :?](./images/smilies/icon_confused.gif)
Type 25 is made available in the hashed file stage icon .
Thats my 2 cents for this one.
When is the interview
![Question :?:](./images/smilies/icon_question.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
A couple of things need to be modified in the previous comment:
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)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: