I have a Job that needs to read 12 different tables from the same MSSQL database.
Is it better to use 1 tMSSqlConnection and set all 12 tMSSqlInput to "Use Existing Connection"? Or is it better to keep the database parameters local to each tMSSqlInput?
Thank you in advance!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema