Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the purpose of indexes?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Differentiate primary key and partition key?
How can we check the version of Teradata that we are using currently?
Explain teradata architecture in detail with a diagram.
What do you mean by fastexport in teradata?
What is dimensional modeling?
List out some of the primary characteristics of teradata.
Explain BYNET.
What are normalization, first normal form, second normal form and third normal form?
What are the uses of client software involved in teradata?
What do you mean by caching in teradata?
What are the different functions included in the server software?
What is the command in bteq to check for session settings ?
What is the meaning of Caching in Teradata?
