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.
-
Enter SALES_DATA in the Target
Table text field.
-
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.
-
In the Table Output window, select the
Truncate Table property.
-
Click the SQL button in the bottom of the Table output dialog box to generate the DDL for
creating your target table.
-
The Simple SQL editor window appears with the
SQL statements needed to create the table.
-
Click Execute to execute the SQL statement.
The Results of the SQL statements
window appears.
-
Examine the results, then click OK to close the
Results of the SQL statements
window.
-
Click Close in the Simple SQL
editor window
-
Click OK to close the Table
output window.
-
Save your transformation.