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 is bteq script in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Difference between stored procedure and macro?
What are the available primary index types in teradata.
Name the five phases that come under MultiLoad Utility.
What is the purpose of upsert command?
What is teradata and why it is used?
What is the difference between teradata and oracle?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are normalization, first normal form, second normal form and third normal form?
What is real time and near real time data warehousing?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
If a Node is busy what are the steps you can take to avoid ?
Why managing the data is important?
Steps to create a data model?