Initial loading and delta loading

Initial loading and delta loading are the basic ETL concepts used by any tools in the market.

Initial Loading:-The type of loading that you do for the first time to empty target tables.


Delta loading:-As the volume increases in the target table over the period of time,you would like to load only changes records from source to target table rather than all the data from the source.This type is called delta loading.

The options like "Delete data before loading" and "Auto correct load"should not be related/linked to the above mentioned types of loading.


"Delete data before loading" can be used when you want to ignore all the existing data in the target table and load from scratch from source table.

"Auto correct load" is the option used when you want no duplicate records to be loaded into the target.