Answer Posted / nb
The purge process moves data between and deletes data from three categories of data, or data sets:
The current data set, which contains data that needs to be available to users. Users can change or review the data.
The history data set, which contains data that can only be reviewed or aggregated by users. Users can't change the data.
The dormant data set, which contains data that falls out of the availability threshold but needs to be stored to meet legal or business requirements. This data is archived, so it can't be changed, reviewed, or aggregated by users.
The purge process is configurable and dynamic, so new categories or subcategories can be added to accommodate changes in legal and business requirements. For example, the current data set could be further classified into read-only data and updateable data. By hosting the read-only data on read-only file groups, you can improve SQL Server performance.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
ware house management system is used?
if you use oracle sql*loader , how do you transform data with it during loading?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain the structure of cold fusion?
What is static and local variable?
List down some of the real time data-warehousing tools?
How to define a cube??
What is the definition of cube in datawarehousing?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What are loops in Datawarehousing?
What is the metadata extension?
How to generate iqd file from framework manager?
What are templates in which way it is help full?
What is called data cleaning?
Compare and contrast aggregates & indexes