Execute the SQL statement

Your database table does not yet contain the field DEALSIZE. Perform these steps to execute the SQL statement.

1. Double-click the Write to Database step to open its properties dialog box.

2. Click the SQL button at the bottom of the window to generate the new DDL for editing your original target table. Note that the Write to Database step was built using Table output.

   1. The Simple SQL editor window appears with the SQL statements needed to alter the table.

      

      Simple SQL editor to generate the DDL
   2. Click Execute to execute the SQL statement.

   3. The Results of the SQL statements window appears. Examine the results, then click OK to close the window.

   4. Click Close in the Simple SQL editor window to close it.

   5. Click OK to close the Write to Database window. Note that the Write to Database step was built using Table output

3. Save your transformation.