Skip to Content
0
Former Member
Apr 17, 2014 at 01:29 PM

Custom Clear From Fact Table Package

35 Views

Hi,

Is it at all possible to write a script that would clear data from the fact table even with data audit switched on? We have recently switched data audit on but have lost the ability to run a 'Clear From Fact Table' package. We've written a piece of script logic that will clear a certain portion of our database but it keeps failing, we are thinking this is because we are trying to write directly to the FAC2 table.

I have attached a copy of the script logic to review.

Thanks,

Jamie

Attachments