When the Data Warehouse is refreshed, the BBDW.DIM_MAILPREFERENCE table is not reflecting correspondence code updates when an ETL Refresh takes place.
We are currently evaluating this issue for a fix in a future service pack.
Steps to Duplicate
1. Marketing and Communications functional area > Manage correspondence > Correspondence Codes tab > Add a new correspondence code. 2. Open up any constituent > Communications tab > Preferences tab > Add a new Mail preference using the code created in step 1. 3. Run the ETL Refresh. 4. Marketing and Communications functional area > Manage correspondence > Correspondence Codes tab > Edit the code created in step 1 and update its name to something else. 5. Run the ETL Refresh again. DIM_MAILPREFERENCE table still has the old name value created in step 1 instead of the updated value in step 4.