Answer Posted / qasim
Data purging is just deleting the old data from the tables
in the database.
In my opinion data purging is not needed in transaction
tables/records such as sales, purchase etc.
Suppose you have a database application, which records
security information like logins, logouts, modifications on
the data or audit trails/history of modifications , then
it is obvious that this information will require additional
space. Since this information will help security
administrators for investigation purpose only you can take
a backup of this information and can delete.
Furthermore its up to your requirement, that at a given
point of time you want to retain data for last (N no of
months) then you can keep, otherwise delete all.
| Is This Answer Correct ? | 36 Yes | 7 No |
Post New Answer View All Answers
Could any one explain me how to create cascading prompts?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is real-time datawarehousing?
What are the different types of datawarehosuing?
Explain Association algorithm in Data mining?
Explain the difference between data ware house & data mart?
What is a data profile?
Explain what is a three tier data warehouse?
How to add a number to a macro variable?
What is a cube in data warehousing concept?
Explain what is the extension of file to save template?
Explain what is real time data-warehousing?
Explain what is the data type of the surrogate key?
Explain datawarehousing?
What are diagrams?
