Scenario: Analysis of a name line and assignment of the salutation - 6.3

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

This scenario describes a batch job that analyzes the person names in a file and assigns them a salutation.

The input file for this scenario is already saved in the Repository, so that all schema metadata is available.

Note

Please observe that the data from the input source must all be related to the same country.

  1. In the Repository view, expand the Metadata node and the directory in which the file is saved. Then drag this file into the design workspace.

    The dialog box below appears.

  2. Select tFileInputDelimited and then click OK to close the dialog box.

    The component is displayed in the workspace. The file used in this scenario is called SampleAddresses..

  3. Drag the following components from the Palette into the design workspace: two tMap components, tUniservRTConvertName, and tFileOutputDelimited..

  4. Connect tMap with tUniservRTConvertName first.

    Accept the schema from tUniservRTConvertName by clicking Yes on the prompt window.

  5. Connect the other components via Row > Main.

  6. Double-click tMap_1 to open the schema mapping window. On the left is the structure of the input file, on the right is the schema of tUniservRTConvertName. At the bottom lies the Schema Editor, where you can find the attributes of the individual columns and edit them.

  7. Assign the columns of the input source to the respective columns of tUniservRTConvertName. For this purpose, select a column of the input source and drag it onto the appropriate column on the right side. If fields from the input file are to be passed on to the output file, like the address fields or IDs, you have to define additional fields.

  8. Click OK to close the dialog box.

  9. Double-click tUniservRTConvertName to open its Basic Settings view.

  10. Fill in the server information and specify the country-specific service.

  11. Double-click tMap_3 to open the mapping window. On the left is the schema of tUniservRTConvertName and on the right is the schema of the output file.

  12. Click OK to close the window.

  13. Double-click tFileOutputDelimited and enter the details for the output file.