Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9644 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
Can we collect statistics on table level?
What is spool space?
What are teradata utilities?
How many codd's rules are satisfied by teradata database?
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 are the uses of fact table and dimension table in banking project?
What are the steps involved after the disk manager passes the request?
How to Extract data from multiple legacy systems?
What interface is used to connect to windows based applications?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain some differences between mpp and smp?
why use references rather than pointers in the public api, particularly for arguments which are modified?
When tpump is used instead of multiload?
Mention a few of the ETL tools that come under Teradata.
What is meant by a dispatcher?
