Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9769 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is TPD?
How do you determine the number of sessions?
Why does varchar occupy 2 extra bytes?
Mention a few of the ETL tools that come under Teradata.
What are the string manipulation operators and functions associated with teradata?
What is stored procedure in teradata?
How is the teradata different from oracle?
Explain the types of join supports by teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How can bottlenecks be identified?
Difference between multiload and tpump?
Can you fastexport a field, which is primary key by putting equality on that key?
Difference between stored procedure and macro?
Explain teradata architecture in detail with a diagram.
What is meant by a Clique?
