Define the Data Definition Language (DDL)

DDLs are the SQL commands that define the different structures in a database such as CREATE TABLE. Fortunately, Pentaho can help you create the necessary DDL.

1. Enter SALES_DATA in the Target Table text field.

2. This table does not exist in the target database, so Pentaho can generate the DDL to create the table and execute it. In this scenario, the DDL is based on the stream of data coming from the previous step, which is the Read Sales Data step.

3. In the Table Output window, select the Truncate Table property.

   

   Table Output step Truncate table field
4. Click the SQL button in the bottom of the Table output dialog box to generate the DDL for creating your target table.

5. The Simple SQL editor window appears with the SQL statements needed to create the table.

   

   Simple SQL editor
6. Click Execute to execute the SQL statement.

   The Results of the SQL statements window appears.

7. Examine the results, then click OK to close the Results of the SQL statements window.

8. Click Close in the Simple SQL editor window

9. Click OK to close the Table output window.

10. Save your transformation.