Interested to Buy Any Domain ? << Click Here >> for more details...
plz explain parlla distribution and subtable concept in teradata
- 3 Answers
- 9581 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 the purpose of indexes?
What is the difference between fastload and multiload? Which one is faster?
Highlight the limitations of TPUMP Utility.
What is meant by Teradata Gateway?
Did you write stored procedures in teradata?
if collect stats but it show low confidence why?
What do you mean by teradata intelliflex?
Is multi insert ansi standard?
Steps to create a data model?
What are the different table types that are supported by teradata?
Highlight a few of the important components of Teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What do high confidence, low confidence and no confidence mean in explain plan?
How to Extract data from multiple legacy systems?
How is the teradata different from oracle?
