plz explain parlla distribution and subtable concept in teradata
Answer Posted / karthik
parlla distribution:
This is the key concept of Teradata storing data in parallel, as it uses PI to store data, data is is stored parallel across the AMP's available.
Sub table: This table is created when a Unique secondary Index is created on the table, it will have rowid,data and hash value for the data. It is used to fetch the data using secondary index.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the uses of bynets in multi-node systems?
Explain how spool space is used.
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is the purpose of joins in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Why managing the data is important?
How do you do backup and recovery in teradata?
What is the purpose of indexes?
How is the teradata different from oracle?
When tpump is used instead of multiload?
What are teradata utilities?
What are the available primary index types in teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How to Extract data from multiple legacy systems?
What are the various indexes in teradata?