August 16, 2023

Using the tDataprepRun component to prepare data from a database in a Talend Job – Docs for ESB 6.x

Using the tDataprepRun component to prepare data from a
database in a Talend Job

This scenario applies only to a subscription-based Talend solution.

The tDataprepRun component allows you to reuse an existing
preparation made in Talend Data Preparation,
directly in a data integration Job. In other words, you can operationalize the process of
applying a preparation to input data with the same model.

The following scenario creates a simple Job
that :

  • retrieves a table from a MySQL database, that holds some employee-related
    data,
  • applies an existing preparation on this data,
  • outputs the prepared data into an Excel file.
Use_Case_tDataprepRun_1.png

This assumes that a preparation has been created beforehand, on a dataset
with the same schema as your input data for the Job. In this case, the existing preparation is
called datapreprun_scenario. This simple preparation puts the employees
last names into upper case and isolate the employees with a salary greater than 1500$.

Use_Case_tDataprepRun_2.png


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x