I created a job that read the data(probably certain millions) from csv file, do some transformations and insert the resulted rows into 2 MSsql tables(based on some conditions).
What is the best plan to deploy a similar job:
- deploy the job on server containing the Microsoft SQL server
- deploy the job on the server containing the csv files
- deploy the job on separated server
Thanks in advance.
Could you please let us know if this KB article helps for you?
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.