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 does level of granularity of a fact table signify?
How much data hold in one universe.
After the complete generation of a report who will test the report and who will analyze it?
Explain the data type of the surrogate key?
Explain what are the various reporting tools in the market?
Explain what is real time data-warehousing?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
In microstrategy, how can we direct the sql generated to use a specifc table?
What are session timeout and application timeout?
How can you set the session management?
What is execution plan?
Explain what is a view as it relates to system modeling?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain what is analytical or analytic mean?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
