Answer Posted / navaneeth reddy
Skew factor is distribution of rows of a table among the
available no.of AMP's.
If your table has a chance of using unique primary index,it
is always better to use UPI which ensures the skew factor
around 0%.
If there is no chance of having unique values column in a
table choose a column as PI(primary index) which has less
duplicate values which inturn results in less skew factor.
That is the data will be distributed almost(not exactly
equal percentage) equally to all AMP's.
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Differentiate primary key and partition key?
What is the difference between fastload and multiload?
What is teradata? Also, list out some of the primary characteristics of teradata.
If RDBMS is halted what will you do ?
Describe primary index in teradata. And what are the available primary index types?
How to Extract data from multiple legacy systems?
What are the functions of a teradata dba?
Explain and compare pros and cons of start schemas?
Did you write stored procedures in teradata?
Highlight the limitations of TPUMP Utility.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is the multi-insert?
Explain parsing engine in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the different table types that are supported by teradata?