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


Please Help Members By Posting Answers For Below Questions

What is bteq script in teradata?

642


What do high confidence, low confidence and no confidence mean in explain plan?

598


Difference between stored procedure and macro?

694


What are the available primary index types in teradata.

593


Name the five phases that come under MultiLoad Utility.

591






What is the purpose of upsert command?

597


What is teradata and why it is used?

593


What is the difference between teradata and oracle?

561


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1510


What are normalization, first normal form, second normal form and third normal form?

639


What is real time and near real time data warehousing?

681


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1748


If a Node is busy what are the steps you can take to avoid ?

1880


Why managing the data is important?

598


Steps to create a data model?

671