plz explain parlla distribution and subtable concept in teradata
Answers were Sorted based on User's Feedback
Answer / karthik
parlla distribution:
This is the key concept of Teradata storing data in parallel, as it uses PI to store data, data is is stored parallel across the AMP's available.
Sub table: This table is created when a Unique secondary Index is created on the table, it will have rowid,data and hash value for the data. It is used to fetch the data using secondary index.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / 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 |
Answer / tdguy
Parallel distribution - Due to "shared nothing"
architecture, TD distributes and fetches the data in
parallel. Mainly because of AMP,PE and BYNET.
Subtables - These are created and used by TD, when the
secondary indexes come into picture.
Is This Answer Correct ? | 3 Yes | 0 No |
What happens in a conflict? How do you handle that?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How to copy teradata scripts from ur remote desktop to server machine?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is dimensional modeling?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com
What are the joins in teradata and how many types of joins are there in teradata?
what is single value and Multivalue ?
How can you track login parameters of users in teradata?
Explain the term 'database' related to relational database management system?
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
write lock is compatiable with which type of lock?