DSXchange

HI everyone,

when i run a job with some transformations ,everyting is working fine .i am getting a warning as

jsControlTie1..xfm7: ORA-00001: unique constraint (CSS.PK5) violated

so i am unable to load all the records in the table.

please can any one suggest what should i do in order to get rid of this issue.

thanks in advance

That one's easy. Don't send records to Oracle that violate that particular UNIQUE constraint.

Try storing rejected records to a file and check what's causing the unique constraint violation