1.Yes, We have installed the Purge script.
2. The Maintain jobs were running on the daily basis and were working fine.But it does not purge the fact tables data.(kindly suggest your ideas on this purge issues). The purging is taking place only in the control tables..
3. Yes. We have data more than 900 days in the db.
------------------------------
Anandapriyan Ravichandran
Pointel (formerly Touch Point)
------------------------------
Original Message:
Sent: 08-17-2018 03:52
From: Ivan Ullmann
Subject: Gim Purging not taking place
Anandapriyan,
1. Did you install the Purge2 script in your RDBMS?
2. Did you create a job to run that script at an interval?
3. Does your table structure have enough days of data for the Purge2 job to remove data?
-Ivan
Original Message------
Thanks for your reply..
Yes It has the value as 900 for days_to_keep_gim_facts.
But the purge is not working.. please tell your suggestions
------------------------------
Anandapriyan Ravichandran
Pointel (formerly Touch Point)
Original Message:
Sent: 08-17-2018 02:14
From: Jason Mclennan
Subject: Gim Purging not taking place
Have you configured gim-etl\days-to-keep-gim-facts to your desired value on the GIM application Options? By default it's 400 days.
------------------------------
Jason Mclennan
Commonwealth Bank of Australia
Original Message:
Sent: 08-16-2018 05:56
From: Anandapriyan Ravichandran
Subject: Gim Purging not taking place
Team,
Data purging is not working against GIM fact tables. Maintain job is running successfully. While checking the CTL_PURGE_HISTORY it is showing only the purging status of control tables in the GIM, but not fact tables. Please provide your suggestions on this.
Thanks,
Anandapriyan.R
------------------------------
Anandapriyan Ravichandran
Pointel (formerly Touch Point)
------------------------------