| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: What are the various methods of getting incremental records or delta records from the source systems?
|
| July 07, 2005 07:23:18 |
#2 |
| Kesavan,H. |
Member Since: Visitor Total Comments: N/A |
RE: What are the various methods of getting incremental records or delta records from the source systems
|
| One foolproof method is to maintain a field called 'Last Extraction Date' and then impose a condition in the code saying 'current_extraction_date > last_extraction_date'. |
| |
Back To Question | |
