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 are the vaious etl tools in the market?
Difference between cold fusion 5 and cold fusion mx 6?
Explain what are the various reporting tools in the market?
What is prompt types of prompts?use of prompts syntax of prompt?
How to import vsam files from source to target. Do we need a special plugin?
What is data cleaning? How can we do that?
How to create context?
Why facts table is useful in representing the data?
Explain what are components of reportnet?
Explain what is full load & incremental or refresh load?
How can you communicate with web server (apache or iis) from coldfusion?
What is drill-through?
What are aggregate tables and aggregate fact tables?
What is metadata in context of a datawarehouse and how it is important?
Explain what are the possible data marts in retail sales?
