Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - What is initial load and incremental load?

asked mar September 20, 2014 06:32 AM  

What is initial load and incremental load?


1 Answers

answered By Mswami   0  
Initial load means, when ever the target table is empty on that time we load from starting year data to up to this day data we are loading into the target like facts or dataware house or datamarts.This is initial loading.

Incremental loading means just coming data that means today data that data load into target table this is called as incremental loading(already previous data is loading into targets then just now coming data is loading into target table that means updated data)it takes loading time is 3 to 4 hours. 

Another difference that the initial load jobs were set to first truncate the tables and then do a complete load and the incremental load was set to insert new rows and update existing rows for DIMENSION Tables. Facts jobs were same (truncate and complete load).
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!