#1 2012-05-22 17:09:43

rcn0706
Member
Registered: 2012-04-23
Posts: 32

UNLOAK bulk capabilities

Tags: [development]

How can I help improve performance when loading data from a large source table beside using cursor?  Can someone please give me an example?  I got tip from using the tOracleOutputBulkExec and it seems to help in saving data to the target table.

Thanks so much.

Offline

#2 2012-05-22 21:51:08

phobucket
Member
Company: Knoetry
Registered: 2010-07-27
Posts: 146
Website

Re: UNLOAK bulk capabilities

You could use Oracle's  spool command to dump the data to a flat file.

https://forums.oracle.com/forums/thread … p;#9963144

Last edited by phobucket (2012-05-22 21:52:41)

Offline

#3 2012-05-22 22:14:18

rcn0706
Member
Registered: 2012-04-23
Posts: 32

Re: UNLOAK bulk capabilities

But that is something you have to do on the side?  I would like to know how to do it using Talend DI?
Thanks.

Offline

Board footer

Powered by FluxBB