Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is Analysis Services?
What are fact, dimension, and measure?
What is dimension modeling?
What are the different types of schemas used in data warehousing?
Explain where do we use semi and non additive facts?
Explain what are fact, dimension, and measure?
What are the steps of implementing data warehousing?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain how many ways you create ports?
Explain what is ods (operation data source)?
Explain degenerate dimension table?
What is data mart in data warehouse?
Whether dimension table can have numeric value?
Difference between cold fusion mx 6 and cold fusion mx 7?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
