I just installed Talend Open Studio 6.4.1 version in my local PC.
I want to transfer the data (around 6.8 Millions) from Oracle DB and writes to a flat file (around 2GB in size) without any transformations in between. I designed a job and running, it is taking much time to load. In Talend it is taking 30 mins to load 1 lakh records.
I need your expert advise how to improve performance and also please let me know if I am doing anything wrong.
toracleInput --> tFileOutputDelimeter
Solved! Go to Solution.
Thanks for your answer. It helps me lot.
I have use Cusrsor set 50000 record , Now it finish 90 sec to complete 5 lakh records.
Can able to increase more data transfer?
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.