plz explain parlla distribution and subtable concept in teradata
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
How will you solve the problem that occurs during update?
What is logical data model?
How does hashing happens in teradata?
What is the function of parser component in teradata?
How can bottlenecks be identified?
What are the different functions performed in development phase?
What are the different methods ot loading a dimension table? A fact table etc?
List out all forms of LOCKS that are available in Teradata.
Explain the teradata primary index mechanics in detail with a diagram.
Explain the term 'columns' related to relational database management system?
What are the 5 phases in a multiload utility?
How to find duplicates in a table?
What is a node in teradata?
Different phases of multiload?
Highlight a few of the advantages that ETL tools have over Teradata.