Inserting data in a table with multiple unique indexes

[splayer]

I am getting "unique constraint error" when I am doing this. I am doing incremental load of the table. The only solution I found is truncating the table and reloading the data which is very slow.

My job has 2 Ora stages. First Ora stage gets the data from source and second one loads the destination.

[ml]

You can create a (hash file) lookup with this table and check the existing keys, also you can compare the changes and use an insert/update option.

With oracle another option could be truncate then use ora bulk load.

regards,