- 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 % ???