Interested to Buy Any Domain ? << Click Here >> for more details...
1.what is activity count?
2.what is skew factor?
how it's working explain brefily
- 5 Answers
- 32633 Views
- Satyam, I also Faced
- E-Mail Answers
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 are normalization, first normal form, second normal form and third normal form?
Explain amp in teradata?
Comment whether bottleneck is an error or not.
What is a clique?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What are aggregate tables? How do you design them using teradata?
What happens in a conflict? How do you handle that?
How can you track login parameters of users in teradata?
How is MLOAD Teradata Server restarted after execution?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
How do you see a ddl for an existing table?
What is the use of stored procedures in teradata?
Highlight the differences between Primary Key and Primary Index.
How to identify ppi columns?
What is the difference between teradata and oracle?
