Are you sure it's not Upsert?
Just in case try next load with new values for a record or a PK.
Thanks for your response.
I found below explanation for insert operation in IICS documentation.
When you run a task with the Insert task operation, Data Integration inserts all source rows into the target. If
Data Integration finds a source row that exists in the target, the row fails.
What I am trying to understand is,
When I ran Sync Task with same source data, it is appending every time in target. Then what is meaning of
"If Data Integration finds a source row that exists in the target, the row fails." in documentation and also how duplicate data getting inserted though PK is there on table.
Do you see two rows in the target table with same PK value?
Can you check the target DDL once. Also show me a sample entry in the target showing the PK getting inserted twice.