1.what is activity count?
2.what is skew factor?
how it's working explain brefily
Answer Posted / tdguy
activity count - rows processed by sql.
skew factor - distribution of data over the amps.
when the distribution is highly skewed, the amp working may
be affected, which inturn affects parallelism.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the functions of a Parser?
If RDBMS is halted what will you do ?
How will you solve the problem that occurs during update?
Explain fallback in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Why is the case expression used in teradata?
What are the functions involved in shared information architecture?
Difference between inner join and outer join?
What is smp and mpp platforms?
What are the design features involved in teradata?
What are normalization, first normal form, second normal form and third normal form?
Explain the term 'columns' related to relational database management system?
What are the different methods ot loading a dimension table? A fact table etc?
Highlight a few of the advantages that ETL tools have over Teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.