STEPS TO REPRODUCE:
Expected Results: The job to run in a timely manner
Actual Results: The job takes 2-3 hours to complete
In the AUDIT_HISTORY table we see different culprits:
DWH_INV_PERIOD_FACTS Taking 1-1,5h
DWH_INV_TEAM_PERIOD_FACTS Taking from 20 min to 1h
DWH_RES_PERIOD_FACTS from 20 min to 50 min
DWH_FIN_TRANSACTION taking 20 to 30 min
Release : 15.8.1+
Component : CA PPM DATA WAREHOUSE
This is DE59914, in review by Engineering