Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9510 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Parallel distribution: TD stores the data uniformly. Ideally, every amp should have equal no of rows from each table in vdisks.Based on the primary index, the distribution of data would be uniform on amps.
Sub table: It is used for secondary indexes and stored in amp(s).
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is collect statistics?
how many modules are there in telecome domain?how to explain the architecture?
any one answer me how they can analyzing the project using data ware housing?
What are tpump utility limitations?
What is primary index and secondary index?
What is the command in bteq to check for session settings ?
What are some commonly used bteq scripts?
What are the various indexes in teradata? How to use them? Why are they preferred?
Explain and compare pros and cons of start schemas?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain the advantages of partitioned primary index in a query?
What are the functions performed by bynet?
What is the difference between global temporary tables and volatile temporary tables?
Where is teradata rdbms used?
How to select first n records in teradata?
