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
Explain what is the difference between datawarehouse and bi?
Explain dimensional modelling?
How to generate the cubes in framework manager?
I know of using applysimple, but there are other ways too?
What are target types on the server?
Explain the importance of data warehouse?
Explain the difference between oltp and olap?
Explain what are the different types of join operations?
What is difference between model & package?
How to join 3 database like flat file, oracle, db2 in informatrica?
Is there any default username & pwd for bo designer & supervisor?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Compare cold fusion with other programming languages?
Describe the differences between a data warehouse and data mart.
How to provide security in frame work manager for a query subject?
