From the DDL you posted, the STUDENT_ATTENDANCE table doesn't have a primary key, only the backup table does. Let's assume it does though and I suggest creating the PK with the IGNORE_DUP_KEY option on. Then load the data and run the duplicate check again to see if it returns any records.