I have a very simple query selecting a set of columns from a particular table using tOracleInput component, followed by a tmap and then tOracleOutput. There is a small lookup table with the input component. But the throughput of tOracleInput is very very low (around 3 rows/sec) which is not acceptable for loading 650-700k records.
I am not using any tOracleConnection component. I also saw that the job firsts reads all the rows from the lookup table and then starts reading from the main Input component.
Can anybody help me out with the issue. It needs urgent resolution from our side so an early response would be highly appreciated!
The cost looks decent although it is full table scan (since its taking maximum value, we will have to live with that).
Are you facing issue when running the same query from Talend? Could you please increase the memory parameters from current value to double in advanced area of run tab and see the results?
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
