Initial and Incremental Load Validations

What are Initial Load validations and Incremental load validations ?

Showing Answers 1 - 2 of 2 Answers


  • 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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions