Create the Customer Type field and add it to the MDW.

Steps:

1. Right click the Customer table in the DSA Data Warehouse and select Add Field
2. Type CustomerType in the Field name box and click OK button
3. Expand Customer table and right click the CustomerType field and select Field Transformations
4. Select Fixed value in the Operator drop-down box of the Field Transformations pane
5. Type Reseller in the Value box and click Add button
6. Type Retail Customer in the Value box and click Add button
7. Right click the Field Transformation Fixed value Reseller and select Add Condition
8. Click the field StoreID in the Conditions pane, select Is not empty in the Operator drop-down box and click Add button
9. Right click the Field Transformation Fixed value Retail Customer and select Add Condition
10. Click the field StoreID in the Conditions pane, select Is empty in the Operator drop-down box and click Add button
11. Click the Customer table in the MDW Data Warehouse and drag the CustomerType field from the Data Movement pane on to the Customer table name.
12. Deploy and Execute the project using option Only modified tables and views