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
- 14930 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 |
What do you mean by caching in teradata?
What is the difference between union and union all in teradata?
How many types of index are present in teradata?
if a error occured in FASTLOAD is the fastload job stops?
What is collect State in Teradata ? what it use and how it works??
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain and compare pros and cons of start schemas?
How is MLOAD Client System restarted after execution?
How a Referential integrity is handled in Teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
how to load or extract the error table data ?
Teradata 
