For this specific case, I was trying to load data for Plan Type 1, which has a different set of dimensions from Plan Type 2. The customer & product dimensions are not valid for Plan Type 1. Note the settings from the dimension library for both dimensions.
From the setup tab in FDMEE, click Target Application. We need to remove Customer & Product from the “Data Table Column Name” column:
Remove the values for Product & Customer and click save:
Then click refresh metadata:
After refreshing the metadata, go back to the Data Load Workbench and import the data file. The import & validate steps should complete successfully now: