Unable to add a custom table to the DWH schema without it being truncated

book

Article ID: 196980

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Is there a naming convention or option to use to prevent the Load Data Warehouse job from truncating a table when the Full load is selected. We have some audit tables that we would not like truncated.

 

Environment

Release : 15.8.1,15.9,15.9.1

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

We have checked and the Full Load of Data Warehouse will truncate all the tables. We raised an Enhancement: 

DE57009 Unable to add a custom table to the DWH schema

Fixed in 15.9.2

 

STEPS TO REPRODUCE:

  1. Add any custom table to DWH schema
  2. Add records in there
  3. Now run Load Data Warehouse - Full Load

Expected Results: The Load Data Warehouse not to truncate a custom table

Actual Results: The Load Data Warehouse truncates custom tables

DWH_CFG_PRECONFIG_SP needs to be changed to exclude custom tables. I.e. it can be done to exclude anything starting with Z_, which is the usual best practice for custom naming

 

Workaround: You could either change DWH_CFG_PRECONFIG_SP to exclude your tables, or use the naming DWH_TRD_x for your audit tables for now. Keep in mind that some trend jobs may also be deleting info. Do not run the cleanup procedure we have for trends (not available via UI). Any customizations and potential loss of information will be responsibility of the customer