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?

Tweet Share WhatsApp

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'.

Download Oracle ETL PDF Read All 39 Oracle ETL Questions
Previous QuestionNext Question
What is a three tier data warehouse?What are the various tools? - Name a few?