plz explain parlla distribution and subtable concept in teradata
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
Describe primary index in teradata. And what are the available primary index types?
What are the different table types supported by teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What is basic teradata query language?
What are the various etl tools in the market?
Why does varchar occupy 2 extra bytes?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
How to Extract data from multiple legacy systems?
How do you verify a complicated sql?
Write a program to show the parser component used in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
How many codd's rules are satisfied by teradata database?
Difference between star and snowflake schemas?
What is the difference between fastload and multiload?
What is oltp?