GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  ETL
Go To First  |  Previous Question  |  Next Question 
 ETL  |  Question 21 of 65    Print  
How to determine what records to extract?

  
Total Answers and Comments: 3 Last Update: November 05, 2005   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 14, 2005 18:44:07   #1  
Praveen        

RE: How to determine what records to extract?
Data modeller will provide the ETL developer the tables that are to be extracted from various sources.
 
Is this answer useful? Yes | No
August 23, 2005 09:53:07   #2  
Andy        

RE: How to determine what records to extract?
When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date > 1st of current mth) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes.
 
Is this answer useful? Yes | No
November 05, 2005 06:44:09   #3  
dvs        

RE: How to determine what records to extract?

draw the inference if slowly changing dimension and based on the Type 1/2 or3 tables defined.


 
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