We are in a plan to move our project from existing Informatica to Talend. I have hands-on Informatica but beginner in Talend. To perform a test run , I just installed Talend Open Studio 6.4.1 version in my local PC.
Few of our ETLs reads data(around 6.8 Millions) from a synonym from Oracle DB and writes to a flat file (around 2GB in size) without any transformations in between. It is just passthrough.
When I designed a job and running, it is taking much time to load. Attached file contains statistics when I use different components with different options. In Informatica, it is taking 30 to 40 mins to load 6.8 Millions records data , but 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.
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