Hi i tried the method...for first time insert it is working fine but after updating the existing records in source table i am getting warning message such as "ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (OT_TGT_DEV1.EMP_SCD2_FLAG_PK) violated" ? and if i remove the constraints after updating the records its still flowing as a new insert? what i missed in this maping? if you can explain?
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
Very nicely explained
Hi i tried the method...for first time insert it is working fine but after updating the existing records in source table i am getting warning message such as "ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (OT_TGT_DEV1.EMP_SCD2_FLAG_PK) violated" ? and if i remove the constraints after updating the records its still flowing as a new insert? what i missed in this maping? if you can explain?
You might be making the business column as a primary key. You have to make the surrorgate key as primary and not any business column.
For help troubleshooting errors, please open a new support case at network.informatica.com. UA-cam comments do not create a support case.