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
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is bteq utility in teradata?
What is dimensional modeling?
What is the syntax for case when statement?
Why managing the data is important?
List out some of the primary characteristics of teradata.
How do you determine the number of sessions?
What is the difference between union and union all in teradata?
What are the components provided on node?
How to run a query in teradata?
What does Amp contain and what are all the operations that it performs?
What are the various indexes in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What do you mean by caching in teradata?
What is the use of stored procedures in teradata?