Capgemini interview question

Target table is uniquely distributed with UPI, mload work table highly skewed. ?

Interview Answer

Anonymous

9 Aug 2011

Because Mload process data in 65KB blocks and try to have consistent blocks, s o if base data type is near to consistent then it will go in one block and remaining in others.So work table distribution does not depends on Targets UPI.