Output data - 6.1

Talend Open Studio for Big Data User Guide

English (United States)
Talend Open Studio for Big Data
Talend Studio
Design and Development

We want to load into the database, California clients living in a couple of Counties only: Orange and Los Angeles counties.

The table structure is slightly different, therefore the data expected to be loaded into the DB table should have the following structure:

  • 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, we will need to use the following mapping process:

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 a 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.