plz explain parlla distribution and subtable concept in teradata
Answer Posted / yuvaevergreen
Parallel distribution: TD stores the data uniformly. Ideally, every amp should have equal no of rows from each table in vdisks.Based on the primary index, the distribution of data would be uniform on amps.
Sub table: It is used for secondary indexes and stored in amp(s).
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between global temporary tables and volatile temporary tables?
What do you mean by tpt in teradata?
What are the different table types supported by teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
Where is teradata rdbms used?
What are the advantages of teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the functions performed by bynet?
Describe primary index in teradata?
Name the five phases that come under MultiLoad Utility.
What is TPD?
Highlight a few of the advantages that ETL tools have over Teradata.
How to find duplicates in a table?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Highlight the points of differences between the database and user in Teradata.