Configuring Spoon output steps

You can use output steps to write data back to the database.

About this task

Table output and table output mapping stores information to a database. This information is then used in the fact tables. When you have all the information to save a transform, you can add output steps to the end of your transform and connect them to the last step.

Procedure

  1. Double-click and add the connection information and the fact table you want to use as the output table.
  2. When it is set up and the steps are connected, right-click the table output step.
  3. Select Generate mapping against this target step.
  4. Map the source fields to the target fields in the target database and select OK.
    Source fields include the additional fields added to the input stream. Ensure to set the table mapping before you use variables in the table input step.
  5. To complete your transform, drag the mapping step in between the last two steps.
  6. If necessary, you can modify and add more fields to the mapping step.