tOracleInput to tOracleOutput running very slow

Highlighted
One Star

tOracleInput to tOracleOutput running very slow

Hi,

I have created a job that runs a complex query using tOracleInput, takes the results and loads them into a new table using tOracleOutput. The query is running in parallel and takes 2.5 hrs to run - this part I know about and cannot do much more to tune. However, when the main link starts writing to the new table it is only managing 1 row/s. The query is designed to take 100k rows so the write part is taking days to run.

I know from using create table as in Toad that creating the table using SQL only does not create much more impact on performance than the query execution time.

An I going about this in the wrong way or is there an issue in performance using a main row join?

Thanks

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog