Here are some cool and quick tips for performance tuning in Kettle.
1. Distribution of Data: Change Number of Copies to Start-This Step is helpful for distributed architecture i.e. if your system has multiple processors, this step will use each of them efficiently for a particular selected step. In order to select this, Right Click on any Step of Transformation.
Now to see this option, you can change the default value (which is 1) to something more.
Value=Number of processors-1
Make sure to set type of data movement (Right Click on a step) to ‘Distribute’.
This step will partition […]