Procedure
-
Double-click tMysqlInput to open its
Basic settings view.
- Select the Use an existing connection check box to use the database connection that you have defined on the tMysqlConnection component.
- To define the schema, select Repository and then click the [...] button to choose the database table whose schema is used. In this example, the target table holding the aggregated data is selected.
- In the Table Name field, type in the name of the table you want to query. In this example, the table is the one holding the aggregated data.
- In the Query area, enter the query statement to select the columns to be displayed.
-
Save your Job and press F6 to execute
it.
The source table is deleted.A two-column table citizencount is created in the database. It groups citizens according to their nationalities and gives their total count in each country.