Hash Maps in TeraData
Hash Maps
DSW (Distribution Selection Word)
Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training
Hash Map provides a relationship between row hash value[DSW] and Amp address Primary index Physical Mechanism [Storage & retrieval Party id mechanism] 
The dates distribution in the Amp’s and amp contains the data in rowed logical Sequence
Inside the Amp
Sel * From party where Pid=2
Hash synonym(or) Hash collisions
- Getting the same row hash values for the same (or) to PI value is called hash synonym(or) Hash collision.
- In this situation to identify every row system takes a concept called rowed.
- It is useful to identify every record unique in the amp.
- It is taken by the amp only.
- It contains 64 bits first 32 bits are row hash value, next 32 bits are u values.
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
About Author
Name
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox