August 15, 2023

Preparing the bulk loading file – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Preparing the bulk loading file – Docs for ESB 6.x

Preparing the bulk loading file

  1. Double-click the tFileInputDelimited
    component to open its Basic settings
    view.

    Use_Case_tSalesforceOutputBulk1.png

  2. In the File name/Stream field, browse to or
    enter the path to the input data file. In this example, it is
    D:/SalesforceAccount.txt.

    In the Header field, type in 1 to skip the header row in the beginning of the
    file.
  3. Click the […] button next to Edit schema and in the pop-up schema dialog box,
    define the schema by adding four columns Name,
    ParentId, Phone and
    Fax of String type.

    Use_Case_tSalesforceOutputBulk_schema.png

    Click OK to save the changes and close the
    dialog box.
  4. Double-click the tMap component to open its
    map editor and set the transformation.

    Use_Case_tSalesforceOutputBulk_tMap.png

  5. Select all columns from the row1 input
    table and drop them to the out output
    table.

    Append .toUpperCase() in the Expression cell for the Name column in the
    out output table.
    Click OK to validate the transformation and
    close the map editor.
  6. Double-click the tSalesforceOutputBulk
    component to open its Basic settings
    view.

    Use_Case_tSalesforceOutputBulk2.png

  7. In the Bulk File Path field, browse to or
    enter the path to the CSV file that will store the transformed data for bulk
    processing.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x