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
Using Exception Table and Primary Key constraint
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'