plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 8453 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
If RDBMS is halted what will you do ?
What is meant by a dispatcher?
Describe primary index in teradata. And what are the available primary index types?
Discuss the advantages of using partitioned primary index in a query?
Explain the term 'database' related to relational database management system?
What are the steps to create a data model?
What are the uses of bynets in multi-node systems?
What is the command in bteq to check for session settings ?
What is the difference between fastload and multiload? Which one is faster?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
How do you determine the number of sessions?
What is the primary index in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are normalization, first normal form, second normal form and third normal form?
What are the primary characteristics of the Teradata.
