Oracle ETL Interview Question:

What are the various methods of getting incremental records or delta records from the source systems?

Submitted by: Administrator

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'.
Submitted by: Administrator