DSXchange

Hi,
I want to know the better way of loading a Oracle table(10g).

While loading millions of records into Oracle table, which option should be chosen for better performance (without any deadlock issue)?

- Using Upsert
- Splitting the data stream into 'Insert' & 'Update' stream and using
two Oracle Enterpise stage as target

Thanks in advance !
Ankita

ankita wrote:Hi,
I want to know the better way of loading a Oracle table(10g).

While loading millions of records into Oracle table, which option should be chosen for better performance (without any deadlock issue)?

- Using Upsert
- Splitting the data stream into 'Insert' & 'Update' stream and using
two Oracle Enterpise stage as target

Thanks in advance !
Ankita

Hi Ankita,

I believe its the second option
Using different streams for insert and update.

Thanks
George

Hi Antika,
I'd better use sql*loader rather than a straight sql statement !
Especially if you have millions records
All the best
M.