hi gurus,
iam doing join of 2 tables in my source stage.
its compiling and running without any errors, but its not loading in the target database.
plz help me, iam getting warning.
[DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-00001: unique constraint (SCOTT.SYS_C001342) violated.
plz help me ,
cheers;
vijay
regarding peculiar error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 56
- Joined: Mon Oct 16, 2006 7:32 am
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
johnthomas wrote:If you truncate the target table and load the data this error should not occur
![Shocked :shock:](./images/smilies/icon_eek.gif)
You do realize why that is, yes? You removed all records from the target table then loaded your set - and there were no duplicates in your source data. Hopefully that's what you intended to happen, each run would entirely replace whatever was there with the current load's data.vijaykumar wrote:i changed my update action to- clear the table and then insert rows. iam not getting any error.
It's only a SCOTT table, I know, but still...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers