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...


Explain about Skew Factor?

Answers were Sorted based on User's Feedback



Explain about Skew Factor?..

Answer / sat!sh

The data distribution of table among AMPs is called Skew Factor

Generally For Non-Unique PI we get duplicate values so the
more duplicate vales we get more the data have same rowhash
so all the same data will come to same amp, it makes data
distribution inequality,

One amp will store more data and other amp stores less
amount of data, when we are accessing full table, The amp
which is having more data will take longer time and makes
other amps waiting which leads processing wastage

In this situation (unequal distribution of data)we get Skew
Factor High

For this type of tables we should avoid full table scans

ex:
AMP0 AMP1
10000(10%) 9000000(90%)

in this situation skew factor is very high 90%

Is This Answer Correct ?    79 Yes 3 No

Explain about Skew Factor?..

Answer / sricharan

It is a number.It tells you how the data is distributed
among Processors or Amps.Skew factor varies about 0-100.
If the data is distributed evenly among the processor the
skew factor is ZERO whether it is smaller or large table.
Skew factor doesn't depends on size of table but it only
depends on distribution of data.

If the skewfactor is more we have to access the table on
only primary index columns but not whole table.

Is This Answer Correct ?    26 Yes 0 No

Explain about Skew Factor?..

Answer / yuvaevergreen

Skew Factor is the indication of how evenly the data is
spread across the AMPS.

A skew factor of 0 indicates that the data is perfectly
distributed across all the AMPS.

Is This Answer Correct ?    17 Yes 1 No

Explain about Skew Factor?..

Answer / navaneeth reddy

Skew factor is distribution of rows of a table among the
available no.of AMP's.
If your table has a chance of using unique primary index,it
is always better to use UPI which ensures the skew factor
around 0%.
If there is no chance of having unique values column in a
table choose a column as PI(primary index) which has less
duplicate values which inturn results in less skew factor.
That is the data will be distributed almost(not exactly
equal percentage) equally to all AMP's.

Is This Answer Correct ?    12 Yes 0 No

Explain about Skew Factor?..

Answer / yuvaevergreen

Below query can be used to find the distribution by amps.
SELECT HASHAMP(HASHBUCKET(HASHROW(index or column)))
,COUNT(*)
FROM TABLENAME GROUP BY 1 ORDER BY 2 DESC;

Is This Answer Correct ?    3 Yes 0 No

Explain about Skew Factor?..

Answer / srinu

The Table is having too many Duplicate rows, The Skew table
will hadle the duplicate rows up to limitations,Once its
cross the no of Rows it will effect on Performence.The Dba
people will the SKEW tables.

I think this Answer helps u

Is This Answer Correct ?    10 Yes 29 No

Post New Answer

More Teradata Interview Questions

Highlight the differences between Primary Key and Primary Index.

0 Answers  


What is the function of parser component in teradata?

0 Answers  


What does Amp contain and what are all the operations that it performs?

0 Answers  


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

0 Answers  


What is real time and near real time data warehousing?

0 Answers  


What are the updated features of teradata?

0 Answers  


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

0 Answers  


Why AMP & PE are called Vprocs?

4 Answers  


What are the functions performed by bynet?

0 Answers  


How is MLOAD Client System restarted after execution?

0 Answers  


I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,


Categories