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

How do you set the session mode parameters in bteq?

1138

---

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2218

---

How to run a query in teradata?

1143

---

Describe the set operators in teradata.

1046

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1142

---

Highlight a few of the advantages that ETL tools have over Teradata.

1133

---

What is basic teradata query language?

1162

---

What are the scenarios in which full table scans occurs?

1050

---

What are the enhanced features in teradata v2r5 and v2r6?

1183

---

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

1250

---

Which is faster fastload or multiload?

1176

---

What do you mean by teradata intelliflex?

1167

---

What is the use of having index on table?

1040

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1250

---

What is the primary index in teradata?

1278

---