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
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 |
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 |
What is the purpose of joins in teradata?
What is the use of having index on table?
what are the uses of fact table and dimension table in banking project?
What do you mean by parsing?
how can i answer for question like teradat architecture in interveiw
What is the purpose of using case expression in teradata?
In Teradata, what is the significance of UPSERT command?
If a Node is busy what are the steps you can take to avoid ?
What happens in a conflict? How do you handle that?
How to run the Teradata jobs in unix environment ???
How to identify ppi columns?
which option is used to restart the fast load script?