Developer forum

I'm trying to create an integration that pulls sales restriction data from an OData source and loads it into the EcomAssortmentPermissions table in DW 10.  In my case, the itemCategoryCode maps to the AssortmentID and the customerNumber maps to the customer number of the user.  Mapping looks like this:



The problem is that since I can't use customerNumber as a key column (because it's mapped to the AssortmentPermissionCustomerNumber field, which is a virtual column) only 45 rows are actually imported of the 106k rows in the source.  I suspect this is because DW is treating itemCategoryCode as the entire key of the staging table and therefore de-duping out all but one record per category.  I tried adding another mapping with customerNumber as a key and not mapping it to any destination column, but the integration seems to discard any mappings that don't have a destination.  I also have a unique "code" column that I could use as a singular primary key and tried mapping that to the AssortmentPermissionExternalId column, but since that column is also virtual, it can't be used as a key either.  Is anyone aware of a way to make this work?