How does rows store in Teradata
- 1 Answers
- 6728 Views
- I also Faced
- E-Mail Answers
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 |
How do you select an index for a table
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
What is ole db used for?
What is the difference between a stored procedure and a query?
What is sqlcode -923 ?
What are database connection details?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
can u combine pipeline parallelism and partition parallalism? how and whan?
issues involved in modeling and building data werahouses
What is the DIF format and when we will use in teradata
What are different types of blocks used in stored procedure?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
