Solved! Go to Solution.
assuming your database is healthy this is probably a limitation of the network throughput between the database and where talend is running. Some options are to avoid transferring data across the network are:
* tOracleRow - if you can write your process as a single sql statement ( insert into ... select from )
* tOracleSP - put your process in a stored procedure and call it
* use ELT components - tELTOracleInput, tELTOracleMap, tELTOracleMap
there is a bit of a learning curve with the ELT components as they work quite differently than other components. This is because they primarily for generating SQL.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables