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 joins in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
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
List the logical and conditional operators that are used with teradata along with their meanings?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
if collect stats but it show low confidence why?
What does Amp contain and what are all the operations that it performs?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
any one answer me how they can analyzing the project using data ware housing?
Highlight the advantages of PPI(Partition Primary Index).
What is bteq script in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Difference between stored procedure and macro?
What is upsert statement in teradata?