Configuring Spoon output steps
You can use output steps to write data back to the database.
About this task
Procedure
- Double-click and add the connection information and the fact table you want to use as the output table.
- When it is set up and the steps are connected, right-click the table output step.
- Select Generate mapping against this target step.
- 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.
- To complete your transform, drag the mapping step in between the last two steps.
- If necessary, you can modify and add more fields to the mapping step.