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
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is teradata and why it is used?
What is database exceptions in teradata?
What are the string manipulation operators and functions associated with teradata?
Describe primary index in teradata. And what are the available primary index types?
What is meant by a Highest Cost Plan?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Define views in teradata with general syntax.
What is node? How many nodes and amps used in your previous project?
What is a clique?
What is spool space?
Highlight all the modes that are present under Confidence Level.
What are the various indexes in teradata?
What is meant by a node?
Explain the term 'row' related to relational database management system?
