Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain what is full load & incremental or refresh load?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Difference between cold fusion 5 and cold fusion mx 6?
Explain what is type 2 version dimension?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are the different types of datawarehosuing?
How much data hold in one universe.
How can you clear the cache?
What is an error log table in informatica occurs and how to maintain it in mapping?
Compare cold fusion with other programming languages?
What is cost benefit analysis (cba)?
How can you import tables from a database?
What is pre-emptive and non-pre-emptive?
What is Sequence clustering algorithm?
Why should you put your data warehouse on a different system than your oltp system?
