Load Data Warehouse performance issue after including a dynamic lookup attribute

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• A new dynamic lookup attribute has been created, in the investment object
• It has been marked for inclusion in the Data Warehouse
• Since then, it is noticed that the 'Load Data Warehouse' job takes significantly longer to complete, in its 'full load' mode.

Environment

• Clarity 16.3.2.

Resolution

• Fix the custom dynamic lookup SQL code.