As part of my design, I plan to have partitions holding historical data. Since the underlying data will have been deleted from the underlying DW, I want to ensure that the partition cannot be re-processed.
Does anyone know if this can be done and, if so, how?
Ta
Dirc
No this cannot be done. Also, please be advised, that your decision to have AS to be a primary data source is not a scenario that AS was designed for. Data Warehouse should be a primary data source. If you absolutely cannot keep data there, you need to have good backup strategy to be able to restore your AS partition data if something happens to it.|||Sadly, the decision as to the removal of data from the DW is not in my hands. It's initial intention is not as a DW but simply as a DSS database for recent data. Since the requirement is to be able to look at 10 years data (eventually) I have no other option.
I think the workaround (read HACK) would be to set the query binding for the partition so that it would immediately generate an error if anyone decided to process it. That and regular backups after each day's processing should keep me sleeping at night.
No comments:
Post a Comment