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 |
Can any one plz provide the teradata interview questions?
How will you solve the problem that occurs during update?
Hash collision?
Highlight the differences between Primary Key and Primary Index.
What are the multiload utility limitations?
Why FLOAD does not support multiset tables??
Did you write stored procedures in teradata?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
What are normalization, first normal form, second normal form and third normal form?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
What is the command in bteq to check for session settings ?
What are the differences between TerdataV2R5 and V12 Versions please??