Duplicate records created via a transform map for the records who are not in global domainIssue Duplicate records are created via transform map even if there is a coalesce on a field mapping when there is no domain column added to the import set table. Import set runs successfully without error and creates the duplicate record if there is a record in the target table with the same field ( the coalesce is on that field ) with a specific domain not in global domain.CauseThis issue happens when the target table has a specific domain rather than Global domain. If the import set table (staging table) does not have the domain field, the system accepts all the records are as in Global domain by default.ResolutionTo sort out the duplicate entries, please follow the below procedure : Navigate to the table's list view. In this case, type your_staging_table.list in the navigation filter.Right-click the list header and select Configure > List Layout.In the Create new field section, enter sys_domain as the Name and Domain ID as the Type.Click Add.Click Save. This is explained in: Add a domain field to a table