DWH Full load and incremental Load are failing with
ERROR: ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_LOOKUP_LOAD XXXXXXXX.
ON CONFLICT DO UPDATE command cannot affect row a second time
Release : 15.9.2
Component : CA PPM SAAS DATA WAREHOUSE
The lookup hidden key value is not unique.
We need to ensure that the Hidden Key of the lookup is unique.