Oracle Extract transform load (ETL) Question:
Download Questions 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'.

Download Oracle ETL Interview Questions And Answers PDF

Previous QuestionNext Question
What is a three tier data warehouse?What are the various tools? - Name a few?