Has anybody come across this error
1. I created a temporary table LT_cntnt_idtnERROR 3147: Duplicate MERGE key detected in join [(DV0.cntnt_idtn x v_temp_schema.LT_cntnt_idtn) using cntnt_idtn_b0 and subquery (PATH ID: 1)]; value [1581846,000000,LBCKTX]
2. I then Loaded this table using copy statement.
3. Then used merge statement to update the target table DV0.cntnt_idtn using temporary table LT_cntnt_idtn.
The very first time it went fine, no errors
But second time, If I load the same file from copy statement and try merging the above error pops.
What is this cause of this error ? And any mitigation steps for this.