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 the concept of Virtual field?
Explain database partitioning.
what is the full procedure for using store procedure in informatica7.1?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
What is a sequence? Explain it with one example?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
How do you select an index for a table
what is cardinality
What is the Lock Based Protocol used for?
What is the differnce between Order by and Group by
What is a database example?
Which is the best sorting method if i have to sort the students of Harvard University according to their first name?
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)