Initial Load and Delta Load

Difference Between Initial Load and Delta Load :

Initial Load :

Ø       Occurs Once

Ø       Large amount of Data

Delta Load :

If the data service has the capability to return the data modified only after a specified date and time, the ETL process will load only the data modified after the last successful load. This is called delta load

Ø       Occurs regularly

Ø       Adjustments to Initial load

Ø       Small amount of data