DSXchange

When you will use Append mode to insert data into the final table, Enterprise stage create a working table, all the rows are written into that table thats what the log is saying Rows written: 153,027,180. After this step the data is copied to target table using the following query
INSERT INTO TARGETTABLE
SELECT * FROM WORKTABLE

so according to the log there are 4 rows which are already present in the target table so they are dropped, and thats why Input rows: 153,027,176

But log says that 153,027,180 records inserted from staging table. Please refer the below line of log:

Rows inserted from staging table: 153,027,180

How many records should be coming through if you run a SQL for it ? are they 153,027,176 or 153,027,180? how about debugging it by putting a remove duplicate stage after the source and then inserting it ?