Using Spoon's built-in optimization tools

Spoon being the developer's tool box, many of the tools used to fine tune and optimize transformations and jobs can be found within the interface. Developers should strive to tune their processes to match the load that it will be processing. Performance is normally measured in a few ways: CPU, RAM, and bandwidth usage, as well as the number of records that can be processed within a given timeframe. With this recipe, we'll dive into the different tools and some of the common techniques that can be used to improve performance.

Getting ready

The transformation and job used in this recipe are available via Packt's website. The example job executes the transformation, which in turn processes some randomly generated values and inserts them into a database table. The transformation is built to not run properly and have issues on execution. The recipe will walk through how to identify those issues using Spoon's built in tools.

How to do it...

Follow the steps...