Oracle Extract transform load (ETL) Question: Download Oracle ETL PDF
What are the various methods of getting incremental records or delta records from the source systems?
Answer:
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'.
Previous Question | Next Question |
What is a three tier data warehouse? | What are the various tools? - Name a few? |