@roshnitripathy8141
Very nicely explained
@juliburnwal9940
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?
@nadim6641