Load DWH job is taking longer time to complete after including an Aggregated Attribute into DWH

Products

• Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE: 
1. Login to Clarity.
2. Navigate to Administration -> Objects -> Status Report Object -> Overal Status Attribute. 
3. Click on Build Calculated Attribute and use expression Max(cop_cost_eft_status,cop_schedule_status,cop_scope_status).
4. Navigate to Administration -> Objects -> Project -> Create new Attribute -> Data Type Aggregated -> Expression AGG_Max(cop_prj_statusrpt.cop_overall_status) and Filter  ( Status Report Latest = 1 ).
5. Include this attribute in DWH.
6. Run the Full DWH Load

Expected Results :- Job takes comparatively normal time compared to previous runs
Actual Results :- Job takes significantly more time to complete.

Environment

Release : Clarity SaaS 16.0.0, PostgreSQL

Cause

This is caused by Defect DE64035

Resolution

This is under review by Engineering team for future consideration. There is not yet an ETA on when this will be addressed