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 |
What is a Database?
What are the types of indexes that are present inside a database?
what is Normalization means..?
8 Answers AZTEC, Bank Of America, Infosys, TCS,
What are the advantages of normalizing a database.
what is transaction state, buffer management, shadow paging
Differentiate between extension & intension?
Explain transaction manager?
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
What is difference between data and database?
can anyone please tell what are the roles and responsibilities of a teradata developer in detail???
Which three commands cause a transaction to end?
Its possible to use auto increment in oracle or not? If no means why?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)