plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 8164 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain Teradata performance tuning and optimization?
What are the available primary index types?
What is meant by a Channel Driver?
In BTEQ, how are the session-mode parameters being set?
What is the purpose of joins in teradata?
What are the available join types in teradata?
Differentiate primary key and partition key?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Highlight the advantages of PPI(Partition Primary Index).
What are default access rights in teradata? What explicit right can be given to a user?
What is the purpose of using case expression in teradata?
How can bottlenecks be identified?
What are the uses of client software involved in teradata?
Describe primary index in teradata?
How to view every column and the columns contained in indexes in teradata?
