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 type of indexing mechanism do we need to use for a typical datawarehouse?
What is static and local variable?
Define Data Warehousing?
What is latest version of power center / power mart?
Explain how are the dimension tables designed?
What is data warehosuing hierarchy?
What a static and local variable?
What is many-to-many dimensional model in datawarehousing ?
what is user variable in affinium campaign? and some real time examples.
Explain what are necessary tasks to install reportnet software?
Where do we use semi and non additive facts?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is a real-time data warehouse?
Explain about core dimension,
How many project sources we can create in metadata?