plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 8452 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
Why does varchar occupy 2 extra bytes?
What is the primary index in teradata?
What are the uses of client software involved in teradata?
How to find duplicates in a table?
What is the purpose of indexes?
Why do you get spool space errors? How do trouble-shoot them?
Explain teradata vs. Redshift?
What is bteq script in teradata?
Explain how spool space is used.
What is the purpose of joins in teradata and what are the available join types?
What is called partitioned primary index (ppi)?
Explain fallback in teradata?
List out teradata data types?
Why managing the data is important?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
