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

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

719

---

What is logical data model?

867

---

What are differences between teradata and ansi session modes in teradata?

859

---

what is object level locking ? where do appear this type of locking ?

3292

---

What is the primary index in teradata?

800

---

Difference between multiload and tpump?

835

---

What is basic teradata query language?

825

---

How to run a query in teradata?

792

---

What is the multi-insert?

793

---

In Teradata, what is the significance of UPSERT command?

790

---

Explain the teradata primary index mechanics in detail with a diagram.

742

---

In Teradata, how do we Generate Sequence?

781

---

How can we check the version of Teradata that we are using currently?

813

---

Discuss the advantages of using partitioned primary index in a query?

715

---

How is MLOAD Teradata Server restarted after execution?

899

---