DWH Incremental Load Performance issue with many Investments

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

DESCRIPTION: DWH Incremental Load Performance issue for DWH_INV_INVESTMENT and DWH_INV_INVESTMENT_LN table

SUMMARY: DWH Incremental Load Performance issue for DWH_INV_INVESTMENT and DWH_INV_INVESTMENT_LN table

 

STEPS TO REPRODUCE: 

1. Login to Clarity System with about 34,173 Investments and about 52 Lookups in investment 

2. Run the DWH Full load and notice that it completes successfully within less amount of time(~40 mins)

3. Run the DWH incremental Load without modifying anything and we notice that it also completes successfully within less amount of time(~33 mins).

4. Make an update on a CIT

5. Re-run the DWH incremental Load.

 

Expected Results: DWH incremental should complete within less amount of time.

Actual Results: DWH incremental takes more than 76 mins to complete with maximum time taken on DWH_INV_INVESTMENT and DWH_INV_INVESTMENT_LN table.

Workaround: Use full load of DWH

Resolution

This is under review as DE77608.