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 ?
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
Highlight the points of differences between the database and user in Teradata.
Explain the term 'row' related to relational database management system?
What are the joins in teradata and how many types of joins are there in teradata?
How to identify ppi columns?
What is the primary index in teradata?
What are the different design perspectives used in teradata?
Explain teradata vs. Redshift?
What is the difference between global temporary tables and volatile temporary tables?
What is upsert statement in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Highlight a few of the advantages that ETL tools have over Teradata.
what are the uses of fact table and dimension table in banking project?
What are the various reporting tools in the market?
How does hashing happens in teradata?
What exactly do you know about catching in teradata?