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 default access rights in teradata?
What is the maximum number of dml can be coded in a multiload script?
What is the meaning of Caching in Teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Differentiate database data and data warehouse data?
What does sleep function does in fast load?
What are the things to be considered while creating secondary index?
What is the function of parser component in teradata?
What are the various indexes in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
List out all forms of LOCKS that are available in Teradata.
What is the command in bteq to check for session settings ?
What is oltp?
What are the multiload utility limitations?
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?