How does rows store in Teradata

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What the various ways to tune a teradata query

2869


Can you create a database in word?

632


what is the role of auditor in auditing data oriented applications?

2018


What is database and its types?

639


Write a query to get maximum and second maximum in oracle?

693






List the properties of a transaction.

714


What are the advantages of using database?

634


What is ole db used for?

668


What are the tools used for backup and ticketing?

656


A design problem was given in which I was supposed to make a design for the data base for a given problem.

637


WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2561


What is lagging in DBMS ?

917


What are the advantages of normalizing a database.

690


How to do Data integrity testing? Who does this testing (Developer or tester)?

1693


What is aws documentdb?

724