Primary key violation Warnings

[tanaya.deshpande@tieto.co]

Hi

I have a load job in which there is One SCD stage, a Join Stage.
Data is being loaded into a SQL server thru a SQLServer Stage.
the insert mode is update then insert.
My Primary key is the surrogate key which is Employeekey generated by the SCD stage.
I am getting Primary key violation Warnings.

Though there are no duplicate primary keys in the database.

can any body say why...

[ray.wurlod]

Though there are no duplicate primary keys in the database.

If that is true you can not get primary key violation warnings. Check again.

Code: Select all

SELECT KEY_COL, COUNT(*) FROM TABLE GROUP BY KEY_COL HAVING COUNT(*) > 1;