ashokkumar

• Jul 5th, 2017

 

Initial load means when ever the target tables are empty that time we are going to load the data from starting year up to this day data loading into data warehouse or data mart is called initial load. It will take 20 to 30 hours of time.

Incremental load means day to day transactions data we are going to load into the target table.this is called incremental load. It will take 3 to 4 hours time

Bedanta Hazarika

• Sep 23rd, 2017

 

Initial or Fresh load refers to the state where we truncate or delete all the records from target table and do a fresh load of Data from source.
Whereas in incremental load we update the old records or add new records, here we do not delete old records. In case of Incremental load we can use merge condition and have to be careful about duplicate values.This we can avoid by properly selecting the fields/columns in the ON condition of merge.
Hope this will be helpful.