Load DWH is taking much longer after a run of a GD Resource Adapter job

Products

• Clarity PPM SaaS

Issue/Introduction

The Load DWH incremental job is taking longer on Resource related facts tables. 

 

Environment

Release : 16.0

Component : PPMDWH

Cause

A Global Delivery Adapter was updating EVERY resource.
The Incremental Load Data Warehouse job uses the Last Modified Date column to determine what rows to load.

Since every resource was updated, after the GD adapter, the Incremental Load DWH was pulling all of the resource data.

Resolution

Configured the GD adapter to run after hours so the next run of the Incremental Load DWH will also be after business hours.