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;

Which is more efficient group by or distinct to find duplicates?

1034

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2094

---

What is the meaning of Caching in Teradata?

1080

---

What is teradata and why it is used?

1012

---

What are the joins in teradata?

920

---

Explain the term 'columns' related to relational database management system?

988

---

What is node? How many nodes and amps used in your previous project?

1061

---

What is the use of stored procedures in teradata?

941

---

Explain teradata utilities?

981

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1997

---

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

926

---

What are the available primary index types?

1148

---

What are the main components of teradata system?

1066

---

During the Display time, how is the sequence generated by Teradata?

968

---

What is called partitioned primary index (ppi)?

959

---