title: I want to improve pentaho performace for data loading
body: <p>I have 4 million records that needs daily load of data from source to target and we are doing truncate everyday. It takes like 9 hours as there are like 10 tables doing 4 million records data loading every day. 
  Could you please tell me how do i improve the performance. Thanks</p>