How to UPDATE a big table in Oracle via Bulk Load

[Former Member]

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

[Former Member]

Hi,

You cannot do bulk load when you need to UPDATE a field. Because all a bulk load does is add records to your table.

Since you have to UPDATE a field, i would suggest to go for SCD with

source > TC > MO > KG >target

Arun