Oracle Extract transform load (ETL) Question:

What is Full load & Incremental or Refresh load?

Oracle ETL Interview Question
Oracle ETL Interview Question

Answer:

Full Load: completely erasing the contents of one or more tables and reloading with fresh data.

Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.


Previous QuestionNext Question
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?How to determine what records to extract?