Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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 ?

Question Posted / supraja_25

Answers were Sorted based on User's Feedback



Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,d..

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

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,d..

Answer / 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

More Teradata Interview Questions

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,

Explain PDE.

0 Answers  

Explain BYNET.

0 Answers  

What is the use of fallback?

0 Answers  

What is the diffrence between Multiload & Fastload interms of Performance?

8 Answers   Cap Gemini, Intel,

Describe primary index in teradata. And what are the available primary index types?

0 Answers  

what is single value and Multivalue ?

1 Answers   IBM, Wipro,

why use references rather than pointers in the public api, particularly for arguments which are modified?

0 Answers  

What are two examples of an OLTP environment?

4 Answers  

What is teradata?

0 Answers  

Find 2 highest sal from each dept who have completed 5 year in org

0 Answers   Wipro,

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

For more Teradata Interview Questions Click Here
Categories