Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9583 Views
- TCS, I also Faced
- E-Mail Answers
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 is upsert statement in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Define views in teradata with syntax.
what are the roles and responsibilities of teradata DBA ?
What are the enhanced features in teradata v2r5 and v2r6?
Difference between star and snowflake schemas?
What are the components used in smp and massively parallel processing (mpp) machines?
In your project what type of issues and errors you facing in Teradata
What are normalization, first normal form, second normal form and third normal form?
what is DYNAMIC SQL in TD?
Hash collision?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
Teradata 
