The Load Data Warehouse (DHW) Incremental job is taking a long time to complete even though no data has been modified. Most of this time is spent on DWH_INV_TASK_HIERARCHY.
STEPS TO REPRODUCE:
Expected Results: The Incremental job to complete within a reasonable time
Actual Results: The Incremental job is taking 40 min to 1h although no data has been modified. Most of this time is spent on DWH_INV_TASK_HIERARCHY
Release : 15.8. 15.8.1, 15.9, 15.9.1, 15.9.2
Component : CLARITY DATA WAREHOUSE
This is caused by DE57828
Fixed in Clarity 15.9.3
See also KB: Data Warehouse (DWH) known issues