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 node? How many nodes and amps used in your previous project?
What is the use of teradata system software?
How will you solve the problem that occurs during update?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Why are oltp database designs not generally a good idea for a data warehouse?
What is a clique?
Explain the term 'primary key' related to relational database management system?
In BTEQ, how are the session-mode parameters being set?
why use references rather than pointers in the public api, particularly for arguments which are modified?
List out some of the primary characteristics of teradata.
What is the difference between teradata and basic rdbms?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is dimensional modeling?
What is upsert statement in teradata?
What is the use of having index on table?