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
- 32818 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
Explain the term 'primary key' related to relational database management system?
Describe the between keyword in teradata?
Define views in teradata with syntax.
How is MLOAD Client System restarted after execution?
What is primary index and secondary index?
What is the multi-insert?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is meant by a Least Cost Plan?
What are some primary characteristics of teradata?
Highlight the differences between Primary Key and Primary Index.
What are the design features involved in teradata?
Explain and compare pros and cons of snow flake schemas?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain teradata utilities?
How do you do backup and recovery in teradata?
