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 purpose of indexes?
What is a dimension table?
What is meant by a Least Cost Plan?
What are the enhanced features in teradata v2r5 and v2r6?
During the Display time, how is the sequence generated by Teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
List out teradata data types?
What is the primary index in teradata?
how many modules are there in telecome domain?how to explain the architecture?
How to load specific no.of records using bteq, or fastload,or multiload
What is the command in bteq to check for session settings ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Explain teradata utilities?
How can you track login parameters of users in teradata?