Output data structure - 8.0

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.