Load DWH Full load fails with error SQLERRM : ORA-00001: unique constraint (PPM_DWH.DWH_LKP_XXXXXX_U1) violated.
STEPS TO REPRODUCE:
1. Login to Clarity.
2. Create a parameterized lookup which gives duplicates without the inclusion of Parameter.
3. Create an attribute and associate this attribute to Lookup.
4. Include the attribute in DWH.
5. Run the DWH Full Load
Expected Results : Job Completes Successfully.
Actual Results : The Job fails with ORA-00001 unique constraint violation.
Release : 16.0.0.1, 16.0.1
Component : CLARITY DATA WAREHOUSE
This is caused by defect DE64044
This defect is resolved on the following versions:
Workaround :