GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing
Go To First  |  Previous Question  |  Next Question 
 Data Warehousing  |  Question 48 of 98    Print  
If you source data from a system that you (warehouse team) have no authority to enforce data quality at the source level, how do you handle this? Do you apply data validation just after you stage the data? Or do you enforce it at the “end” of the flow (typically as you’re pushing it into the data mart)? Or do you not enforce validation at all?

  
Total Answers and Comments: 3 Last Update: September 09, 2009     Asked by: sreya 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 09, 2006 13:26:58   #1  
ambuji david        

RE: If you source data from a system that you (warehou...
the position is challenging and need in depth knowledge in answering questions related to this branch of IT
 
Is this answer useful? Yes | No
March 17, 2007 05:23:29   #2  
Nitin        

RE: If you source data from a system that you (warehou...
One of the main purpose of Datawarehousing is to get Cleanse data.
So skipping data validatons is not a good idea.
It will be better to bring the data to a staging area and perform validations.
Or while pushing data from the source we can perform data validations.

 
Is this answer useful? Yes | No
September 09, 2009 21:57:26   #3  
Dominique Member Since: September 2009   Contribution: 1    

RE: If you source data from a system that you (warehouse team) have no authority to enforce data quality at the source level, how do you handle this? Do you apply data validation just after you stage the data? Or do you enforce it at the “end”

A DW is no longer relevant when it contains inconsistent data. The strength of a DW - and its robustness - also relies on the validation processes... The sooner you can detect and report any inconsistency the better it is. Wrong data must be trapped as soon as possible within the ETL processes.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape