1.what is activity count?
2.what is skew factor?
how it's working explain brefily
Answer Posted / vinay sir(datawarehousing tech
ActivityCount:The number of rows processed in the previous
sql statement it defines.
EG: if there is a table party is having 14 rows then
SELECT * FROM PARTY;
.ACTIVITYCOUNT= 14
Skewfactor:
It tells the distribution of the rows.
-->If uniformly distributed(normal distribution) skew
factor is 0.
-->Skew factor is the reversal of Parallel efficiency.(if
skew factor is 10 then parallel effciency is 90).
There is aformula to identify the skewness.
Please find the below.
SELECT TableName,SUM(CurrentPerm) AS
CurrentPerm,SUM(PeakPerm) AS PeakPerm,(100 -
(AVG(CurrentPerm)/MAX(CurrentPerm)*100)) AS SkewFactor
FROM Dbc.TableSize
WHERE DataBaseName = 'VINAY'
GROUP BY 1 ORDER BY 1
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is oltp?
Difference between multiload and tpump?
Write a program to show the parser component used in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How to Extract data from multiple legacy systems?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the components provided on node?
Different phases of multiload?
What is the use of virtual processor connectivity in teradata?
What's the difference between timestamp (0) and timestamp (6)?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain parsing engine in teradata?
What do you mean by teradata sql assistant?
What are the various indexes in teradata? How to use them?