Output data - 6.2

Talend Real-time Big Data Platform Studio User Guide

English (United States)
Talend Real-Time Big Data Platform
Talend Studio
Data Quality and Preparation
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.