Load Data Warehouse Audit

Products

• Clarity PPM SaaS

Issue/Introduction

The field dw_updated_date is updated every time the Load Data Warehouse job is completed, however it only shows the start date and time.

 

Environment

Release : 15.9.1

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

The DWH table (dwh_cfg_audit) can be queried for either the dw_load_start_date or dw_load_end_date associated with the table_name.

The Administration > Security and Diagnostics > Data Warehouse page contains information from the job's last run.
The portlet uses the stock query(Data Warehouse Audit).