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
Explain what is a three tier data warehouse?
Difference between e-r modeling and dimentional modeling?
What are the difference between snow flake and star schema?
What is the limit to the number of sources and targets you can have in a mapping?
What is the difference between olap and datawarehosue?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the difference between agglomerative and divisive hierarchical clustering?
Which component has onread method and what it is used for?
Explain what are the modules in power mart?
How to limit the max no of rows retrieved in the report?
Explain how are the dimension tables designed?
List down some of the real time data-warehousing tools?
Explain the difference between oltp and olap?
What are the data marts?
