Configuring the components - 7.0

Processing (Integration)

EnrichVersion
7.0
EnrichProdName
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 Open Studio for MDM
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Processing components (Integration)
Data Quality and Preparation > Third-party systems > Processing components (Integration)
Design and Development > Third-party systems > Processing components (Integration)

Procedure

  1. Double-click tFileInputDelimited to enter its Basic settings view.
  2. Set Property Type to Repository since the file details are stored in the repository. The fields to follow are pre-defined using the fetched data.
    The input file used in this scenario is called input. It is a text file that holds string, integer, and float java types.
    Fill in all other fields as needed. For more information, see tFileInputDelimited. In this scenario, the header and the footer are not set and there is no limit for the number of processed rows.
  3. Click Edit schema to describe the data structure of this input file. In this scenario, the schema is made of three columns, StringtoInteger, IntegerField, and FloatToInteger.
  4. Click Ok to close the dialog box.
  5. Double-click tConvertType to enter its Basic settings view.
  6. Set Schema Type to Built in, and click Sync columns to automatically retrieve the columns from the tFileInputDelimited component.
  7. Click Edit schema to describe manually the data structure of this processing component.
    In this scenario, we want to convert a string type data into an integer type and a float type data into an integer type.
    Click OK to close the [Schema of tConvertType] dialog box.
  8. Double-click tMap to open the Map editor.
    The Map editor displays the input metadata of the tFileInputDelimited component
  9. In the Schema editor panel of the Map editor, click the plus button of the output table to add two rows and name them to StringToInteger and Sum.
  10. In the Map editor, drag the StringToInteger row from the input table to the StringToInteger row in the output table.
  11. In the Map editor, drag each of the IntegerField and the FloatToInteger rows from the input table to the Sum row in the output table and click OK to close the Map editor.
  12. In the design workspace, select tLogRow and click the Component tab to define its basic settings. For more information, see tLogRow.