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?
Under which circumstance should you create an index on a table?
List the properties of a transaction.
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
Does facebook use graph database?
can anyone please tell what are the roles and responsibilities of a teradata developer in detail???
WHAT KIND OF TOOL BO IS?
What is the difference between primary and candidate key?
Which database does facebook use?
sparse lookup and where its options we find in OCI and db2?
how node connect with cpu?
issues involved in modeling and building data werahouses