Configuring Spoon transform steps

You can use transform steps to change input data or add information to the input stream.

About this task

In the Spoon example transform, the Calculator, Add Constants, and Value Mapper steps are used. You can add a sequence through Spoon but it is not database independent and does not work on SQL Server. Instead, you can use the provided DB Procedure.

Procedure

  1. Use the Value Mapper step to ensure that fields have values or to set fields different values. You can set values to a target field based on the values of a source field. If the target field is not specified, the source field is set instead of the target field. You must ensure that all the fields in a calculation have a value. If a null value is encountered during a calculation the transform fails.
  2. Double-clicking the Value Mapper opens the dialog to input the necessary information. In the Spoon example transform, it is used to set a field to 0 if it does not have a value.
  3. Use the Add Constants step to add constants to the input stream and to set the values that are needed for the NEXTVAL DB Procedure.
  4. You must have this step in all transforms that use the NEXTVAL DB Procedure. Set SEQ_NAME to SEQ_FACTSOID and INCR to 1.
  5. Use the Calculator step to take fields and run a limited set of calculations. It provides a set of functions that are used on the field values. The Calculator step performs better than using JavaScript scripting steps.
  6. The built-in calculations are limited. Select the Calculation column to show the list of available functions.