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;

Explain some differences between mpp and smp?

1080

---

Explain teradata architecture?

1067

---

What is meant by a Least Cost Plan?

1051

---

What is a sparse index?

1068

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2848

---

Explain the types of join supports by teradata?

976

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

1155

---

Differentiate database data and data warehouse data?

1092

---

What is basic teradata query language?

1088

---

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

2039

---

What is meant by a Clique?

1040

---

What's the difference between timestamp (0) and timestamp (6)?

1173

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2190

---

What is TPD?

1355

---

What tools would you use for that?

1089

---