Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9661 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
Mention a few of the ETL tools that come under Teradata.
What do you mean by fastexport in teradata?
What are the different functions performed in development phase?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What do high confidence, low confidence and no confidence mean in explain plan?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is the basic syntax for teradata select statement?
What is collect statistics?
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 functions involved in shared information architecture?
What are aggregate tables? How do you design them using teradata?
What are the 5 phases in a multiload utility?
Which is more efficient group by or distinct to find duplicates?
Define views in teradata with general syntax.
What is a three-tier data warehouse?
