transformation error
Posted: Sat Dec 16, 2006 8:12 pm
hi Gurus,
my source is oracle, my target is oracle.
iam using ODBC STAGE as source and ODBC STAGE AS TARGET.
i can compile and run, but after running the jobs , i can see that the data is not loaded in the target.iam getting warnings, whenever i run the job, i went to view the warnings from the logfile of director.
i got warning as
DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-00001: unique constraint (SCOTT.PK_DEPT) violated.
due to this the data is not loading in the target.
plz help me.
cheers;
vijay
my source is oracle, my target is oracle.
iam using ODBC STAGE as source and ODBC STAGE AS TARGET.
i can compile and run, but after running the jobs , i can see that the data is not loaded in the target.iam getting warnings, whenever i run the job, i went to view the warnings from the logfile of director.
i got warning as
DataStage][SQL Client][ODBC][Oracle][ODBC][Ora]ORA-00001: unique constraint (SCOTT.PK_DEPT) violated.
due to this the data is not loading in the target.
plz help me.
cheers;
vijay