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
- 32886 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
1. >> activity count indicates the no of rows affected/processed by the last request(no of rows returned to bteq from teradata).
2. >> skewness refers to the distribution of rows on the amps.
>> If some AMPs are having more rows and some very less, then skewness would be high. This would affect the parallelism.
3. Following query gives the skewness for all tables.
SELECT ts.DatabaseName
,ts.TableName
,td.CreateTimeStamp AS Created
,td.LastAlterTimeStamp AS LastAltered
,td.AccessCount
,td.LastAccessTimeStamp AS LastAccess
,SUM(ts.CurrentPerm) AS CurrentPerm
,SUM(ts.PeakPerm) AS PeakPerm,
(100 - (AVG(ts.CurrentPerm)/MAX(ts.CurrentPerm)*100)) AS SkewFactor
FROM DBC.TableSize ts
JOIN DBC.Tables td
ON ts.DatabaseName = td.DatabaseName
AND ts.TableName = td.TableName
GROUP BY 1,2,3,4,5,6;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How do you verify a complicated sql?
Mention a few of the ETL tools that come under Teradata.
What do you mean by fastexport in teradata?
Explain teradata architecture?
What is the meaning of Caching in Teradata?
How does hashing happens in teradata?
What are normalization, first normal form, second normal form and third normal form?
What is basic teradata query language?
Explain and compare pros and cons of snow flake schemas?
What is stored procedure in teradata?
What is dimensional modeling?
How can we check the version of Teradata that we are using currently?
What are the joins in teradata and how many types of joins are there in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain the term 'foreign key' related to relational database management system?
