Answer / 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

Answer / 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;

Answer / tdguy

activity count - rows processed by sql.
skew factor - distribution of data over the amps.
when the distribution is highly skewed, the amp working may
be affected, which inturn affects parallelism.

Answer / tdguy

Hi Anjum,
As far as I know, "FROM" option in "IMPORT" mload
command can be used to load specific no of records. I would
suggest to use FROM and THRU option to load.

Answer / anjum

one question please....how do we load firsr five record
through mload?

What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,

Differentiate primary key and partition key?

0 Answers  

Is multi insert ansi standard?

0 Answers  

If table have access lock.In the same table write lock is posible or not?

1 Answers  

What is a dimension table?

0 Answers  

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers   IBM,

What is spool space?

0 Answers  

List out all forms of LOCKS that are available in Teradata.

0 Answers  

where we can use the delimiter in mload? pls let me know

2 Answers   Wipro,

On which column will you take primary index???

4 Answers  

What are the functions involved in shared information architecture?

0 Answers  

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers