Custom multivalued field empty in data warehouse after incremental load when you remove value from the custom MVL attribute

book

Article ID: 128524

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Custom multivalued field empty in data warehouse after incremental load when you remove value from the custom MVL attribute

Cause

STEPS TO REPRODUCE
1. Run a Data Warehouse Full Load so everything is sync'd up.
2. Go to a Project that has Status Reports
3. On a Status Report, delete 1 resource off the custom MVL. Attribute we were using is based on an out of the box resource lookup.
4. Run an incremental DWH Load.
5. The display_value field in the dwh_cmn_mv_lookup table will be null

Expected Results: it should not remove display_value after incremental run

Actual Results: it removes display_value after incremental run