Preparing the source data - 7.1

EXASolution

author
Talend Documentation Team
EnrichVersion
7.1
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
task
Data Governance > Third-party systems > Database components > EXASolution components
Data Quality and Preparation > Third-party systems > Database components > EXASolution components
Design and Development > Third-party systems > Database components > EXASolution components
EnrichPlatform
Talend Studio

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.