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
Explain the teradata primary index mechanics in detail with a diagram.
What is a level of granularity of a fact table?
What is spool space? Why do you get spool space errors?
What is bteq utility in teradata?
what are the day to day activities of teradata DBA ?
How to select first n records in teradata?
List out some of the primary characteristics of teradata.
What are some primary characteristics of teradata?
How does hashing happens in teradata?
Explain the types of join supports by teradata?
How can bottlenecks be identified?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Write a program to show the parser component used in teradata?
What are the frequently used data types in teradata?