:: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Categories >> Software >> Data Warehouse >> Data Warehouse General


 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (853)
 Informatica interview questions  Informatica Interview Questions (1626)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (172)
 Data Stage interview questions  Data Stage Interview Questions (564)
 SAS interview questions  SAS Interview Questions (557)
 Micro Strategy interview questions  Micro Strategy Interview Questions (37)
 ETL interview questions  ETL Interview Questions (196)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
What is Data purging?
 Question Submitted By :: Data-Warehouse-General
I also faced this Question!!     Answer Posted By  
# 1
Data purging is nothing but deleting your data from DW.
Sometimes While loading data into staging or target table
you may need to load fresh data everytimes (called full
load). In this case you need to purge the complete
stage/target table before load it with Fresh data.

Pls point me if I'm worng.
Is This Answer Correct ?    93 Yes 11 No
# 2
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 ?    34 Yes 6 No
# 3
Occasionally, it is necessary to remove large amounts of
data from a data warehouse. A very common scenario is the
rolling window discussed previously, in which older data is
rolled out of the data warehouse to make room for new data.

However, sometimes other data might need to be removed from
a data warehouse. Suppose that a retail company has
previously sold products from Company ABC, and that Company
ABC has subsequently gone out of business. The business
users of the warehouse may decide that they are no longer
interested in seeing any data related to Company ABC, so
this data should be deleted.
This process is data purging.
Is This Answer Correct ?    31 Yes 5 No
# 4
Purging means deleting the old data and creating the space for the new. 
Is This Answer Correct ?    8 Yes 2 No
Ishita Ramani
# 5
The purge process moves data between and deletes data from three categories of data, or data sets:

The current data set, which contains data that needs to be available to users. Users can change or review the data.
The history data set, which contains data that can only be reviewed or aggregated by users. Users can't change the data.
The dormant data set, which contains data that falls out of the availability threshold but needs to be stored to meet legal or business requirements. This data is archived, so it can't be changed, reviewed, or aggregated by users.
The purge process is configurable and dynamic, so new categories or subcategories can be added to accommodate changes in legal and business requirements. For example, the current data set could be further classified into read-only data and updateable data. By hosting the read-only data on read-only file groups, you can improve SQL Server performance.
Is This Answer Correct ?    0 Yes 0 No
# 6
Use the PURGE statement to remove a table or index from your
recycle bin and release all of the space associated with the
object, or to remove the entire recycle bin, or to remove
part of all of a dropped tablespace from the recycle bin.
Is This Answer Correct ?    0 Yes 0 No
# 7
Purging means temperarly removing the data 
Is This Answer Correct ?    6 Yes 18 No
# 8
Information sources may be unreliable and may purge data. On
the other hand, information at the warehouse is under the
control of the warehouse users; it can be stored safely and
reliably for as long as necessary.
Is This Answer Correct ?    8 Yes 50 No

Other Data Warehouse General Interview Questions
  Question Asked @ Answers
Which one among Star and snowflake schemas will occupy more space? Barclays 1
What's a Cube in Rolap? Oracle 2
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null. IBM 1
Is it possible to have more than one row on the same table with the same foreign key?   2
what is a hot file, why we need in datawarehousing, where we used in general Thomson 2
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-   3
What is a ETL/ How does Oracle support the ETL process?   1
What are Data Marts?   2
what is hybrid schema TCS 4
What is surrogate key? IBM 5
2.What is staging area ? HCL 4
For more Data Warehouse General Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright 2013  All Rights Reserved.   ::