Limitations for Assign Identity

AssignIdentity does not work in the following scenarios:

• If business keys are mapped to multiple records, that is, not mapped to unique records.
• If business keys are not reliable and go through cleansing or transformation later. In this case, save the record as a new record and use it for match and merge later.

  AssignIdentity ensures that the unique identity is assigned to records even if duplicates exist in the same run and the saved record does exist in the database.