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
Mention a few of the ETL tools that come under Teradata.
What is dimensional modeling?
What is a clique?
What is the use of teradata system software?
Describe the set operators in teradata.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
In Teradata, how do we Generate Sequence?
Describe the between keyword in teradata?
Highlight the points of differences between the database and user in Teradata.
Explain the new features of teradata?
What are the various indexes in teradata? Why are they preferred?
What is the command in bteq to check for session settings ?
What are normalization, first normal form, second normal form and third normal form?
What is smp and mpp platforms?
What are the available primary index types in teradata.
