Adding a Destination table

You can write the transformation results to an existing table or add a Destination table based on existing ports in the project. You cannot add a table based on a port structure from the Database Configuration window or Properties window. You must select the port structure in the Design window.

StepsWriting to an existing table

  1. In the Database Configuration window, specify the table where you want to write the transformation results. You can click the Destination Table icon to select the table, or manually enter the name of the table in the Destination Table field.

  2. Click Finish.

StepsAdding a Destination Table based on the IN-port

  1. In the Design window, right-click the component, and select Add Destination Table from Input.

  2. Name the new table. Click OK.

  3. In the Add table window, verify if the table information is correct and click Create.

StepsAdding a Destination Table from an existing port

  1. In the Design window, right-click the component, and select Add Destination Table from port.

  2. Name the new table. Click OK.

  3. Select the port whose structure you want to assign to the new table. Click Apply.

  4. In the Add table window, verify if the table information is correct and click Create.

NoteYou can also create a Destination table with your own toolset, or select an existing table from the Properties window.