Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


1.what is activity count?
2.what is skew factor?
how it's working explain brefily

Answers were Sorted based on User's Feedback



1.what is activity count? 2.what is skew factor? how it's working explain brefily..

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

Is This Answer Correct ?    13 Yes 2 No

1.what is activity count? 2.what is skew factor? how it's working explain brefily..

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;

Is This Answer Correct ?    6 Yes 0 No

1.what is activity count? 2.what is skew factor? how it's working explain brefily..

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.

Is This Answer Correct ?    3 Yes 0 No

1.what is activity count? 2.what is skew factor? how it's working explain brefily..

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.

Is This Answer Correct ?    1 Yes 0 No

1.what is activity count? 2.what is skew factor? how it's working explain brefily..

Answer / anjum

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Teradata Interview Questions

What are aggregate tables? How do you design them using teradata?

0 Answers  


Highlight the limitations of TPUMP Utility.

0 Answers  


how many modules are there in telecome domain?how to explain the architecture?

0 Answers  


Explain PDE.

0 Answers  


How can you track login parameters of users in teradata?

0 Answers  


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

0 Answers  


Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,


What is a node in teradata? Explain

0 Answers  


What are the components used in smp and massively parallel processing (mpp) machines?

0 Answers  


How do you eliminate duplicates?

3 Answers  


What happens in a conflict? How do you handle that?

0 Answers  


What is meant by a Highest Cost Plan?

0 Answers  


Categories