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
What is the purpose of using case expression in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is called partitioned primary index (ppi)?
What are some commonly used bteq scripts?
Differentiate database data and data warehouse data?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain the meaning of Amp?
How many types of joins are there in teradata?
Discuss the advantages of using partitioned primary index in a query?
Define views in teradata with general syntax.
What are different table types used in teradata?
Why is the case expression used in teradata?
What is the command in bteq to check for session settings ?
What is meant by a Virtual Disk?
What is the use of virtual processor connectivity in teradata?