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
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain what is analytical or analytic mean?
What is loop in data warehousing?
What is data analysis? Where it will be used?
What are the steps to build the datawarehouse?
What does level of granularity of a fact table signify?
How to provide security in frame work manager for a query subject?
What are target types on the server?
Describe the differences between a data warehouse and data mart.
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What are partition points?
What are the approaches used by optimizer during execution plan?
What is critical column?
