SCD stage gives Primary key violation Warnings
Posted: Mon Jun 03, 2013 6:32 pm
Hi DS Guru
I have job which read data source and insrt or update dimension using SCD stage. One wired thing is it runs ok until I add new column in target table (add same column in refrence table too). becuase of this type 1 column, I got below warining.
One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "EDW.ENTITY" from having duplicate values for the index key
the only constraint is SK, which should be use as key to update or insert. Any idea why this happened?
thanks
I have job which read data source and insrt or update dimension using SCD stage. One wired thing is it runs ok until I add new column in target table (add same column in refrence table too). becuase of this type 1 column, I got below warining.
One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "EDW.ENTITY" from having duplicate values for the index key
the only constraint is SK, which should be use as key to update or insert. Any idea why this happened?
thanks