Hi All,
can anyone tell me how many types of Skew exists? whats the
difference between amp skew,data skew,cpu skew, io skew,
delta amp cpu ?

Answers were Sorted based on User's Feedback



Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,d..

Answer / yuvaevergreen

Adding to above,
Cpu skew->
1 or more AMPs are processing most of the data while other
AMPs are processing very little data.
Max(CPUTime) / Avg(CPUTime) from Ampusage can also give a
CPU skew figure.

Is This Answer Correct ?    6 Yes 0 No

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,d..

Answer / innocent

How many types of Skew exists?

If you utilized unequally TD resources(CPU,AMP,IO,Disk and
etc) this is called skew exists. Major are 3 type of skews
(CPU skew,AMP/Data skew, IO Skew).

-Data skew?
When data is not distribuited equally on all AMPs.
-Cpu skew?
Who is taking/consuming more CPU called cpu skew.
-IO skew?
Who perform more IO Operation. called IO Skew.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Teradata Interview Questions

What is the purpose of joins in teradata?

0 Answers  


What is the use of having index on table?

0 Answers  


what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,


What do you mean by parsing?

0 Answers  


how can i answer for question like teradat architecture in interveiw

4 Answers   TCS,






What is the purpose of using case expression in teradata?

0 Answers  


In Teradata, what is the significance of UPSERT command?

0 Answers  


If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,


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

0 Answers  


How to run the Teradata jobs in unix environment ???

4 Answers   IBM,


How to identify ppi columns?

0 Answers  


which option is used to restart the fast load script?

2 Answers  


Categories