Load DWH Incremental job taking longer to run than expected in versions lower than CA PPM 15.3

Document ID : KB000115923
Last Modified Date : 26/09/2018
Show Technical Document Details
Issue:
The Load Data Warehouse job (DWH) - Incremental is taking longer than normal to run. The query found by the DBA that is taking longer than normal is noted below:

SELECT A.TEAM_KEY,T.INVESTMENT_KEY,T.RESOURCE_KEY,A.PERIOD_KEY, 
CASE WHEN R.RESOURCE_TYPE_KEY <= :"SYS_B_00" THEN A.SOFT_ALLOC_HOURS ELSE :"SYS_B_01" END, 
CASE WHEN R.RESOURCE_TYPE_KEY <= :"SYS_B_02" THEN A.HARD_ALLOC_HOURS ELSE :"SYS_B_03" END, 
CASE WHEN R.RESOURCE_TYPE_KEY <= :"SYS_B_04" THEN A.ALLOC_HOURS ELSE :"SYS_B_05" END, 
CASE WHEN R.RESOURCE_TYPE_KEY <= :"SYS_B_06" THEN A.BASE_HOURS ELSE :"SYS_B_07" END, 
A.SOFT_ALLOC_COST,A.HARD_ALLOC_COST,A.ALLOC_COST,A.BASE_COST,TO_DATE(:"SYS_B_08", :"SYS_B_09") 
FROM DWH_INV_TEAM_PER_FACTS_VZZZZZ
INNER JOIN DWH_INV_TEAM T ON A.TEAM_KEY = T.TEAM_KEY 
INNER JOIN DWH_INV_INVESTMENT I ON T.INVESTMENT_KEY = I.INVESTMENT_KEY 
INNER JOIN DWH_RES_RESOURCE R ON T.RESOURCE_KEY = R.RESOURCE_KEY 
INNER JOIN DWH_CMN_PERIOD P ON A.PERIOD_KEY = P.PERIOD_KEY 
WHERE (T.CLARITY_UPDATED_DATE BETWEEN TO_DATE(:"SYS_B_10", :"SYS_B_11") AND TO_DATE(:"SYS_B_12", :"SYS_B_13")) OR (T.RESOURCE_KEY IN 
(SELECT DISTINCT RESOURCE_KEY 
FROM DWH_X_RES_AVAIL_PER_FACTS 
WHERE DW_UPDATED_DATE >= 
(SELECT DW_UPDATED_DATE 
FROM DWH_CFG_AUDIT 
WHERE TABLE_NAME = :"SYS_B_14"))) 
Cause:
This is caused by DE35329
Resolution:
This issue is fixed in CA PPM 15.3