What is the meaning of skewness in Teradata? When do we use nullif function in Teradata?

arunFERGY

 Profile Answers by arunFERGY Questions by arunFERGY

• May 31st, 2017

Unequal distribution of data on amps is called skewness. Nullif function compares two arguments, if they matches then it returns null else it returns first argument.

msrakesh

• Mar 29th, 2012

When we choose wrong primary index the data unevenly distributed across all the amps means some amps have more records and some amps had less records this is called skewness.
Percentage of skewness is called skew factor.30% skew factor is acceptable.

Answer Question  Select Best Answer