Input and output data

The input file, the data of which will be loaded into the database table, contains customer information of various aspects.

The file structure usually called Schema in Talend Studio includes the following columns:

• id (Type: Integer)

• CustomerName (Type: String)

• CustomerAge (Type: Integer)

• CustomerAddress (Type: String)

• CustomerCity (Type: String)

• RegisterTime (Type: Date)

The tMap component is used to select the id, CustomerName and CustomerAge columns from the input data. Then the selected data is output using the output stream feature.

Thus the expected output data should have the following structure:

• id (Type: Integer)

• CustomerName (Type: String)

• CustomerAge (Type: Integer)

All the three columns above come from the respective columns in the input data.