The Definitive Guide to Data Quality
(approximately 2-4 rows per second)
Yes shalouf, I've tried your suggestion in the past and had the same results that you are describing. The problem is that we should be able to use a tOracleConnection on the tOracleOutput. In your situation, you're requiring the Talend job to create a second connection to the database, which should not be required. The tOracleConnection component is intended to prevent the need for creating a new connection with each component. We should be able to use this component without experiencing performance degradation.