Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9456 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
Explain the advantages of partitioned primary index in a query?
What tools would you use for that?
What is spool space? Why do you get spool space errors?
Explain the term 'row' related to relational database management system?
How will you solve the problem that occurs during update?
In the Primary Index, what is the score of AMPs that are actively involved?
Explain the types of join supports by teradata?
What is the difference between fastload and multiload?
What are the frequently used data types in teradata?
What are tpump utility limitations?
If a Node is busy what are the steps you can take to avoid ?
What are the functions of a teradata dba?
What is the meaning of Caching in Teradata?
What is a node in teradata? Explain
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
