HashedFile

[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

[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

[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

[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.