Question
1
Replies
378
Views
Posted: April 18, 2018
Last activity: May 9, 2018
Closed
Solved
Are there DSS entries to control retention thresholds for various tables? Specifically to ADM tables.
We are implementing the pr_perf_stats retention threshold in DSS as described in the pdn article below. Are there other entries to control retention periods for the tables below relating to ADM?
https://pdn.pega.com/support-articles/how-alter-retention-period-prperfstats-table-cleanup
The requirement is to purge the older then 30 days of data from this two below reporting tables, which are present in PEGA_DATA Schema in XOSCAR. is it possible to have a DSS entry to purge the data from this tables through Pega.
Table: PR_DATA_DM_ADMMART_MDL_FACT
Table: PR_DATA_DM_ADMMART_PRED_FACT
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Hi, I do not think there are any DSS in OOTB PRPC/DSM. (If you need remove adaptive models from the reports, create a dataset on Data-Decision-ADM-ModelSnapshot and run a truncate it.
Or simple truncate the PR_DATA_DM_ADMMART_MDL_FACT table and similarly we can run truncate for PR_DATA_DM_ADMMART_PRED_FACT by taking the back up of the tables)
Regards,
Basavaraj