Configuring Spoon job steps

Even though you are not creating jobs that you need to get Kettle variables and fields into the input stream, you need to ensure that you can set an output field to a variable.

About this task

In the Spoon example transform, the triCreatedByTX and triRunDA variables are brought into the input stream. You also get variables to pull in the ONTIME and DURATION variables so that you can set them during the JavaScript scripting steps.

Procedure

It is important in case there is a failure during a transform to time stamp when the transform is run. The example does it by using the triRunDA variable and this provides an avenue for rollback, even though the process does not have explicit steps for it.

When you are setting fields to values in the transform, they must be the same type otherwise the transform fails.