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 a three tier data warehouse?
How to eliminate duplicate rows from flat file?
Explain what is real time data-warehousing?
Give some difference between oltp and olap.
Explain dimensional modelling?
What are parallel querys and query hints?
What is latest version of power center / power mart?
The same tier?
Explain how are the dimension tables designed?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain the difference between keylokup and joiner?
I know of using applysimple, but there are other ways too?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
what is user variable in affinium campaign? and some real time examples.
How to create prompts in report net?
