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 difference between fastload and multiload? Which one is faster?
Name the five phases that come under MultiLoad Utility.
Explain teradata utilities. What is multiload, fast load, tpump?
Can we collect statistics on table level?
What are the various etl tools in the market?
Mention a few of the ETL tools that come under Teradata.
How to run a query in teradata?
Explain BYNET.
What are the design features involved in teradata?
Explain teradata utilities?
What is the use of virtual processor connectivity in teradata?
What is real time and near real time data warehousing?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are the things to be considered while creating secondary index?
Explain and compare pros and cons of start schemas?