Skew Factors

Database

Skew Factors

Hi,

Here is my Question!!

- I'm loading a table in dev environment using a third party ETL + mload(non staged mode) -here i am getting 1000rows/sec as throput. when i checked my amp distribution, its equal...(i have 11 amps). skew rate is 30

-I'm loading a same table in another environment(stg) using the same tool+mload(same config as in dev) - but am getting only 300rows/sec as throput. amp distribution is equal... (i have 68 amps)..skew rate is 85%...

i want to know why is there a difference of skew when i have same strategy... high systems..(more amps, more space)..

please tell me the solution for this? and also tell me what are the factors for skew % ???

Thanks,
Kottur
Tags (1)
1 REPLY

Re: Skew Factors

Kottur,

How many distinct values do you have in your PI? Could be the issue here?

random