Talend community forum / tOracleOutputBulkExec

shine007 · 2009-05-05 12:04:36

I'm using Talend to port a Sybase ASE DB Schema to Oracle doing some processing with tMap. As for big tables I started using oracleBulk since OracleOut gave me heap memory exception.

The component is working properly, but i was wondering if there is a way not to start the SQL Loader process automatically once the .csv and .ctl files have been written.

Thank you,
Alessandro

Diane2 · 2009-05-05 14:38:00

Yes it does exist: open the advanced settings panel, add a field into the "load option" table and select the most appropriate setting for you... Doing so you will be able to choose a number of input row as trigger for the BulkExec start.

shine007 · 2009-05-05 15:05:58

Diane2 wrote:
Yes it does exist: open the advanced settings panel, add a field into the "load option" table and select the most appropriate setting for you... Doing so you will be able to choose a number of input row as trigger for the BulkExec start.

I'm sorry I can't fully understand...The "load option" field let me configure single SQLLoader options, such as rows per commit or Parallel loads...They are standard Oracle loader options...Do you mean I should use the "SKIP" option setting a "big-enough" value ?

thank for your reply,
Alessandro

Announcement

Unanswered posts

#1 2009-05-05 12:04:36

tOracleOutputBulkExec

#2 2009-05-05 14:38:00

Re: tOracleOutputBulkExec

#3 2009-05-05 15:05:58

Re: tOracleOutputBulkExec

Diane2 wrote:

Board footer