Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9587 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
Explain the advantages of partitioned primary index in a query?
What is a three-tier data warehouse?
What are different table types used in teradata?
how do you manage the production space. what are the proactive methods you can take ?
if collect stats but it show low confidence why?
What is TPD?
Steps to create a data model?
Explain the new features of teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What are the functions involved in shared information architecture?
What do you mean by caching in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the updated features of teradata?
Why teradata is used?
Highlight a few of the advantages that ETL tools have over Teradata.
