topic Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec in Talend Studio

Difference between tOracleBulkExec vs tOracleOutputBulkExec

gpinumalla — Sat, 16 Nov 2024 03:35:52 GMT

Hi All,

What is difference between tOracleBulkExec vs tOracleOutputBulkExec. what gives better performance because I am having some transformations to do in between. I am struck with this issue.

Thank you.

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

fdenis — Tue, 14 Jan 2020 09:03:08 GMT

tOracleBulkExec load a previously created file into oracle

tOracleOutputBulkExec create file and load it into oracle

tOracleBulkExec is include into tOracleOutputBulkExec

Regards,

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

gpinumalla — Tue, 14 Jan 2020 15:05:53 GMT

If I want to use the tOracleOutputBulkExec. How to capture the error records from the component tOracleOutputBulkExec and pass error exceptions to this component.

Let me know.

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

fdenis — Tue, 14 Jan 2020 15:19:32 GMT

you can redirect the output result of bulkload on Advance setting
select output to global variable then you have to read it automatically or manually.

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

gpinumalla — Tue, 14 Jan 2020 16:00:52 GMT

I have selected the Output to the global variable but I when I run my job I want to capture my rejected/error records and map it again and give the error exceptions.

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

fdenis — Tue, 14 Jan 2020 16:32:51 GMT

so you have to parse the output.
the output depend on your oracle driver and session, you can define output format using oracle command before bulk insert.

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

gpinumalla — Tue, 14 Jan 2020 17:04:16 GMT

Hi Denis,

The output results are being captured to global varaible instead of console. what we are looking is for the bad error records are now captured in csv file . we want to capture and pass it in tmap and re- run in a append mode to target database. How do we do that using toracledbbulkexec

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

fdenis — Thu, 16 Jan 2020 09:41:40 GMT

once you've catch output, you have to pase it detecting error line then rerun the corresponding job.

but…
first question: is is it a one shot job?
what is the best method to contrôle the
completeness of the data transfer.

regards,

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

gpinumalla — Thu, 30 Jan 2020 19:23:59 GMT

how to pase it detecting error line then rerun the corresponding job?

this is one shot job that should be transforming , loading to the target oracle table and source oracle table .

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

fdenis — Fri, 31 Jan 2020 09:04:43 GMT

if it's one shot do not use bulk…
bulk is useful for big data table but it's a bit more complicated to stabilise.
so you are going to loos a lot of time.

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

gpinumalla — Fri, 31 Jan 2020 14:49:51 GMT

Yes. I agree, can there be any another approach for this component toracleoutputbulkexec?. I have to take data from soruce oracle table and do some transformations and load into another oracle db table.

current logic is to use the toracleoutputbulkexec.let me know with better approach.

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

Genloga — Tue, 03 Mar 2020 13:47:59 GMT

when you said talend created file ... which file are you talking about ? Source file or control file ?

Re: Difference between tOracleBulkExec vs tOracleOutputBulkExec

gpinumalla — Tue, 03 Mar 2020 14:40:19 GMT

Talend creates a new control file. I am interested to capture rejected rows from the toracleoutputbulkexec. is there a way to capture it.

Let me know