Since upgrading to 16.0, none of the values for the custom multivalue lookup (MVL) attributes are showing in the Data Warehouse (DWH), they are blank in DWH_INV_INVESTMENT
Out of the Box (OOTB) multi-value lookups work as expected. The Load DWH job runs with no issues or errors (both Incremental and Full).
Expected Results: Values are available in the ad-hoc and also in the associated _LN tables, i.e. DWH_INV_INVESTMENT and DWH_INV_INVESTMENT_LN
Actual Results: Values are not showing.
Release : 16.0.0
Component : CLARITY DATA WAREHOUSE
DE63339 / DE63349
If the job is failing refer to this article:
The solution here is to exclude the custom attributes from the DWH which use multi-valued lookups until the patch is applied.