Skewed Fastload job

Tools
Enthusiast

Skewed Fastload job

Fastload Job is CPU skewed by 99%

Job is loading data of 40 million rows and taking 2 hours on a 150 amp system and is skewed for 2 hours  

Inferences

  • Primary index is good . having skew of 1 % only
  • Checkpoint intervel set to 100000
  • no records went to error table

Any idea why this CPU skew happening ?

Thanks in advance !