DWH Incremental Job is not updating some information

Products

• Clarity PPM SaaS

Issue/Introduction

When running a Data Warehouse Incremental job, it's not updating all information as expected. The information not being synced was manually inserted into the database through a Process.

Environment

Release : 15.7.1

Component : CA PPM SAAS APPLICATION

Resolution

Manual insertion of data into the database may not be known as an "update" in the system. If loading information through a Process, you must ensure that the last updated date must be reflect this. If the last updated date remains the same, it will not be synced through an incremental job.