Filtering and aggregating table columns directly on the DBMS

The following scenario creates a Job that opens a connection to a MySQL database and:

For more technologies supported by Talend, see Talend components.

• populates a database table with the input data,

• creates the output table for the filtered data,

• instantiates the schema from a database table in part (for column filtering),

• filters two columns in the same table to get only the data that meets two filtering conditions,

• collects data from the filtered column(s), grouped by specific value(s) and writes aggregated data in a target database table.