Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 2 Answers
- 14811 Views
- I also Faced
- E-Mail Answers
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 |
Why Multiload does not supports USI and supports NUSI?
What is partitioned primary index (ppi)?
How a Referential integrity is handled in Teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
how do you manage the production space. what are the proactive methods you can take ?
How can you track login parameters of users in teradata?
The transaction exceeded the maximum number of rowhash locks allowed
what is the difference between filter and router transmissions
what are the uses of fact table and dimension table in banking project?
What are default access rights in teradata? What explicit right can be given to a user?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
any one answer me how they can analyzing the project using data ware housing?
Teradata 
