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
- 14916 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain and compare pros and cons of start schemas?
Name the five phases that come under MultiLoad Utility.
What is partitioned primary index (ppi)?
What are the scenarios in which full table scans occurs?
During the Display time, how is the sequence generated by Teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Explain the teradata primary index mechanics in detail with a diagram.
What is the difference between teradata and oracle?
What is logical data model?
Can you connect multiload from ab initio?
What is real time and near real time data warehousing?
In Teradata, what is the significance of UPSERT command?
Explain BYNET.
How do you do backup and recovery in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
