Page 1 of 1
HashedFile
Posted: Fri Jul 05, 2002 3:50 am
by vbalacts
I have found that each hashedfile contains two files in server
1) DATA.30
2) OVER.30
Can anyone explain about this? Is OVER.30 something related the OVERFLOW of Hashed file?
Thanks,
Bala
God is an Infinite Circle whose Centre is Everywhere but Circumference is Nowhere
Posted: Thu Jul 11, 2002 10:54 am
by Klaus Schaefer
Exactly,
Data that overflows a group of a dynamic hash file goes into this overflow area. If you find this data growing much, your hash file is probably not very well configured.
Klaus
Posted: Thu Jul 11, 2002 10:19 pm
by vbalacts
Thanks Klaus. Again I need one more help.
I knew that the following are the various Types of hashed File. But can you please explain little further? most variant on right means ??? Is it based on key column values???
Numeric, most variant on right
Numeric & Seperators, most variant on right
64 character ASCII, most variant on right
Numeric, most variant on middle
Numeric & Seperators, most variant on middle
64 character ASCII, most variant on middle
Exactly,
Data that overflows a group of a dynamic hash file goes into this overflow area. If you find this data growing much, your hash file is probably not very well configured.
Klaus
God is an Infinite Circle whose Centre is Everywhere but Circumference is Nowhere
Posted: Wed Jul 24, 2002 7:39 am
by cmueller
The transformer stage accepts only one input stream and all other inputs are reference inputs. Sequential files cannot be used as reference inputs. One way of combining two sequential files would be to load one of them into a hashed file and then use it as a reference in the transformer and the other sequential file as the input stream.