Using Exception Table and Primary Key constraint

Munish · Post by **Munish** » Tue Jan 02, 2007 10:19 pm

Hi Everybody,

I am using Oracle Enterprise stage and using 'load' as Write mode.

Volume of data is more than 100 mills per load.

I need to maintain Primary constraint.
As OCI stage does not like any constraint. It loads the duplicate values and if I try to use the constraints OCI falls over.

?? Can there be better solution than using bulk loader considering the volume.

My another question is regarding Exception table with in OCI stage.
It seems that datastage expect this table before hand.
Can anyone advice me with this table schema.
I Tried with one column varchar, but it did not worked.

Thanks in advance.

Regards,
Munish

ray.wurlod · Post by **ray.wurlod** » Wed Jan 03, 2007 12:03 am

Remove Duplicates stage.

kumar_s · Post by **kumar_s** » Wed Jan 03, 2007 3:47 am

Hi Munish,
Rather than finding a way to insert duplicate rows in table, find the reason why you getting duplicates to the table. And work at the root cause. If its the table that ought to have constraints, the Extract and transformation should be made in such a way that it suites the target. Considiring the volume, bulk load will be the right candidate.