Difference between tOracleBulkExec vs tOracleOutputBulkExec

[gpinumalla]

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. 

[fdenis · Accepted solution]

tOracleBulkExec load a previously created file into oracle

tOracleOutputBulkExec create file and load it into oracle

tOracleBulkExec is include into tOracleOutputBulkExec

Regards,

[gpinumalla]

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. 

[fdenis]

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.

[gpinumalla]

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. 

[fdenis]

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.

[gpinumalla]

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

[fdenis]

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,

[gpinumalla]

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 . 

[fdenis]

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.