Fields transformations let you modify existing data in a number of ways. For example, you can easily reverse the sign of numeric values, trim fields or return a specified number of characters from the original field value. For more detailed information, please see Selecting, Validating and Transforming Data.

Steps:

1. Expand the Product table in the DSA Data Warehouse
2. Right click the ProductModelName field and select Field Transformations
3. Select Fixed value in the Operator drop-down list
4. Type "None" in the Value box and click Add button
5. Right click the Transformation "Fixed Value 'None'" and select Add Condition
6. Select the ProductModelName field in the Conditions pane
7. Leave the value "Is empty" in the Operator drop-down list and click Add button
8. Repeat steps 2 through 7 for ProductCategoryName field and ProductSubCategoryName field.
9. Deploy and Execute the Product table
10. Validate the result using Preview and Query Tool