Load Data Warehouse (DWH) job - Full and Incremental fails with an error on DWH_CMN_MV_LOOKUP:
Error message: ORA-01427 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Release : Any
Component : CLARITY DATA WAREHOUSE
Custom lookup query needs to be updated
Workaround: Before correcting the query, the lookup can be unchecked from the Data Warehouse to allow for the job to run smoothly.
Note: Broadcom Support recommends always testing the inclusion of new attributes to Data Warehouse on a Test environment first.