How does rows store in Teradata



How does rows store in Teradata..

Answer / amish ojha

applying hashing algorithm to the PI system gets the ROW
HASH ,that will be searched in the HASH BUCKET to get the
desired AMP ,thereafter by adding uniqueness value to row
hash value the row ID is obtained and then it gets stored
in AMP ..


PI-->ROW HASH ---> HASH BUCKET(MAP)--> AMPno

ROWID = ROW HASH + UNIQUENESS ID

where actually the row is stored

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Databases AllOther Interview Questions

What is a Database?

0 Answers  


Under which circumstance should you create an index on a table?

0 Answers   3i Infotech,


List the properties of a transaction.

0 Answers  


where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

0 Answers  


Does facebook use graph database?

0 Answers  






can anyone please tell what are the roles and responsibilities of a teradata developer in detail???

1 Answers  


WHAT KIND OF TOOL BO IS?

0 Answers   APC,


What is the difference between primary and candidate key?

0 Answers   BirlaSoft,


Which database does facebook use?

0 Answers  


sparse lookup and where its options we find in OCI and db2?

0 Answers   TCS,


how node connect with cpu?

0 Answers   IBM,


issues involved in modeling and building data werahouses

0 Answers  


Categories