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.