Hash Maps in TeraData

Blog Author


Published Date

12th October, 2020




  • Share this blog :


Hash Maps

Hash Algorithm  

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]     Hash Table

Hash Map  

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


Master Index

Teradata Interview Questions

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.

  Hash Synonym

For In-depth knowledge on Teradata click on:



About Author


Author Bio

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 .

Related Blogs

Write For Us