Output data structure - 8.0

Data Integration Job Examples

Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Talend Studio
Design and Development > Designing Jobs
Last publication date

This scenario loads the data of California clients living in Orange and Los Angeles counties to the database table.

The following lists the database table structure, which is slightly different from that of the input file. As a result, the data to be loaded into the database table needs to be transformed.

  • Key (key, Type: Integer)

  • Name (Type: String, max. length: 40)

  • Address (Type: String, max.length: 40)

  • County (Type: String, max. length:40)

In order to load this table, the following mapping process is needed.

  • The Key column is fed with an auto-incremented integer.
  • The Name column is filled out with a concatenation of first and last names.
  • The Address column data comes from the equivalent Address column of the input file, but supports an upper-case transformation before the loading.
  • The County column is fed with the name of the County where the city is located using a reference file which will help filtering Orange and Los Angeles counties' cities.