plz explain parlla distribution and subtable concept in teradata
Answer Posted / tdguy
Parallel distribution - Due to "shared nothing"
architecture, TD distributes and fetches the data in
parallel. Mainly because of AMP,PE and BYNET.
Subtables - These are created and used by TD, when the
secondary indexes come into picture.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How many types of joins are there in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
What are the various indexes in teradata? How to use them?
What happens in a conflict? How do you handle that?
Explain the new features of teradata?
What are the various indexes in teradata? Why are they preferred?
What is called partitioned primary index (ppi)?
What is meant by a Channel Driver?
How do you do backup and recovery in teradata?
How you will check the version of teradata?
What are the available primary index types?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is a sparse index?
What are the various indexes in teradata?
Explain teradata architecture in detail with a diagram.