Load Data Warehouse Incremental slow on DWH_CMN_MV_LOOKUP

Document ID : KB000125142
Last Modified Date : 22/01/2019
Show Technical Document Details
Issue:
When I run Load Data Warehouse - Incremental, it takes very long time, intermittently. My Full Load runs quite fast. When we check DWH_GATHER_METRICS_V, we see most of the time is taken by  DWH_CMN_MV_LOOKUP.
Cause:
The intermittent slowness of DWH_CMN_MV_LOOKUP on Incremental Load was addressed by Development in user story S150853 in PPM version 15.4.1.
 
Resolution:

To get this issue addressed, plan to upgrade to 15.4.1 or higher (it's best to stay on the most current version).
When you upgrade, the Load Data Warehouse Incremental Load will no longer take that much time on DWH_CMN_MV_LOOKUP.

Until you upgrade, what you could do is schedule a Full Load to run instead, few times per day.