Preparing the source data - Cloud - 8.0

Exasol
Version
Cloud
8.0
Language
English
Product
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 Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database components (Integration) > Exasol components
Data Quality and Preparation > Third-party systems > Database components (Integration) > Exasol components
Design and Development > Third-party systems > Database components (Integration) > Exasol components
Last publication date
2024-02-20

Procedure

  1. Double-click the tFixedFlowInput component to open its Basic settings view.
  2. Click the [...] button next to Edit schema to open the Schema dialog box.
  3. Click the [+] button to add six columns: EmployeeID of the Integer type, EmployeeName, OrgTeam and JobTitle of the String type, OnboardDate of the Data type with the yyyy-MM-dd date pattern, and MonthSalary of the Double type.
  4. Click OK to close the dialog box and accept schema propagation to the next component.
  5. In the Mode area, select Use Inline Content (delimited file) and enter the following employee data in the Content field. 
    12000;James;Dev Team;Developer;2008-01-01;15000.01
12001;Jimmy;Dev Team;Developer;2008-11-22;13000.11
12002;Herbert;QA Team;Tester;2008-05-12;12000.22
12003;Harry;Doc Team;Technical Writer;2009-03-10;12000.33
12004;Ronald;QA Team;Tester;2009-06-20;12500.44
12005;Mike;Dev Team;Developer;2009-10-15;14000.55
12006;Jack;QA Team;Tester;2009-03-25;13500.66
12007;Thomas;Dev Team;Developer;2010-02-20;16000.77
12008;Michael;Dev Team;Developer;2010-07-15;14000.88
12009;Peter;Doc Team;Technical Writer;2011-02-10;12500.99
  6. Double-click the tFileOutputDelimited component to open its Basic settings view.
  7. In the File Name field, specify the file into which the input data will be written. In this example, it is "E:/employee.csv".
  8. Click Advanced settings to open the Advanced settings view of the tFileOutputDelimited component.
  9. Select the Advanced separator (for numbers) check box and in the Thousands separator and Decimal separator fields displayed, specify the separators for thousands and decimal. In this example, the default values "," and "." are used.