plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 8148 Views
- TCS, I also Faced
- E-Mail Answers
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 spool space? Why do you get spool space errors? How do trouble-shoot them?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain BYNET.
How many sessions of MAX is PE capable of handling at a particular time?
What is the purpose of using case expression in teradata?
What are the different table types that are supported by teradata?
What are the frequently used data types in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the 5 phases in a multiload utility?
What is basic teradata query language?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is a three-tier data warehouse?
In the Primary Index, what is the score of AMPs that are actively involved?
How to identify ppi columns?
