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 are the enhanced features in teradata v2r5 and v2r6?
What are the functions involved in shared information architecture?
List out teradata data types?
List out some of the primary characteristics of teradata.
What is primary index and secondary index?
Explain the teradata primary index mechanics in detail with a diagram.
What is the difference between union and union all in teradata?
What are tpump utility limitations?
What are the advantages of teradata?
What is the function of parser component in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain the advantages of partitioned primary index in a query?
What is the maximum number of dml can be coded in a multiload script?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is a level of granularity of a fact table?