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 will you solve the problem that occurs during update?
How would you load a very large file in teradata in general?
What is the purpose of indexes?
When tpump is used instead of multiload?
What is a dimension table?
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 ?
What are the functions involved in shared information architecture?
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
What are the 5 phases in a multiload utility?
Explain PDE.
What are the steps to create a data model?
Explain the term 'columns' related to relational database management system?
What are the joins in teradata?
What is teradata?
how many modules are there in telecome domain?how to explain the architecture?