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


Please Help Members By Posting Answers For Below Questions

How will you solve the problem that occurs during update?

589


How would you load a very large file in teradata in general?

569


What is the purpose of indexes?

597


When tpump is used instead of multiload?

632


What is a dimension table?

610






If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1900


What are the functions involved in shared information architecture?

607


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2354


What are the 5 phases in a multiload utility?

615


Explain PDE.

608


What are the steps to create a data model?

602


Explain the term 'columns' related to relational database management system?

550


What are the joins in teradata?

573


What is teradata?

648


how many modules are there in telecome domain?how to explain the architecture?

1560