Skip to Content
0
Former Member
Apr 15, 2014 at 05:06 PM

How to UPDATE a big table in Oracle via Bulk Load

35 Views

Hi all,

in a datastore target as Oracle 11g, I have a big table having 300milions of record; the structure is One integer key + 10 columns attributes .

In IQ Source i have the same table with the same size ; the structure is One integer key + 1 column attributes .

What i need to do is to UPDATE that single field in Oracle from the values stored in IQ .

Any idea on how to organize efficiently the dataflow and the target writing mode ? bulk load ? api ?

thank you

Maurizio