We are fetching data from PostgresSql(EDB). Having two separate servers one for DB and ETL. While a talend job was called in ETL server, query inside tPostgressqlInput fetch the data using multiple cores(parallel) in DB server. I mean all the cores were utilised based on parallel workers defined.
But in ETL server, only one core was utilized. Specified the cursor size to fetch data in chunk.I doubt, it was because of JDBC driver. For single query(one connection) only one thread will be used? Can't I make the make the job to use multi-threaded while fetching the data using JDBC driver?
What i assume is, data is read sequentially and parallelism works right after tPostgressqlInput, if i enable parallelism in job level. Kindly provide some suggestion, how to make use of multi-cores while transferring data from DB server.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks