Data Warehouse Incremental job performance on very large datasets (Oracle)

Article Id: 110864

Status: Published

Updated On: 17-10-2018 09:13

Products:

CLARITY PPM FOR ITG CA Project & Portfolio Management CLARITY PPM FEDERAL CA Project & Portfolio Management SAAS STARTER PACK-CLARITY PPM

Issue/Introduction:

After upgrade to 15.2 customer found that the Load Data Warehouse - Incremental is taking much longer than the Full Load and takes an average of 12 hours to complete
What could be causing the issue?

Environment:

Release:
Component: PPMDWH

Resolution:

This is a known defect DE38853 and has been fixed in 15.4.1.