Pentaho Data Integration - Create Table's Structure and Copy Data (#012)

Edit the repository and create a new folder called "create_tables_structures"

Select "File", "New" and "Transformation" option, when the transformation is opened click "Tools", "Wizard" and "Copy table".

When the wizard is opened select a source and target database connections.

Choose a table that needs to be copied and click "Finish".

Pentaho automatically creates a new transformation.

Click "File" and "Save as..."
Point the "Directory:" to "create_tables_structures".

Run the transformation and check the results.