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 are default access rights in teradata?

828


What is the maximum number of dml can be coded in a multiload script?

795


What is the meaning of Caching in Teradata?

868


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

855


Differentiate database data and data warehouse data?

774






What does sleep function does in fast load?

813


What are the things to be considered while creating secondary index?

820


What is the function of parser component in teradata?

807


What are the various indexes in teradata?

751


Highlight a few of the advantages that ETL tools have over Teradata.

841


List out all forms of LOCKS that are available in Teradata.

721


What is the command in bteq to check for session settings ?

839


What is oltp?

734


What are the multiload utility limitations?

774


Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

924