Nidhi

• Jun 29th, 2005

 

By Full Load or One-time load we mean that all the data in the Source table(s) should be processed. This contains historical data usually. Once the historical data is loaded we keep on doing incremental loads to process the data that came after one-time load.

Rupesh Shah

• Aug 17th, 2005

 

Full Load is the entire data dump load taking place the very first time. 
Gradually to synchronize the target data with source data, there are further 2 techniques:- 
Refresh load - Where the existing data is truncated and reloaded completely. 
Incremental - Where delta or difference between target and source data is dumped at regular intervals. Timsetamp for previous delta load has to be maintained.

Sriharsha Hanumanth

• Aug 23rd, 2005

 

Full Load: completely erasing the contents of one or more tables and reloading with fresh data. 
 
Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.

Ram

• Feb 28th, 2006

 

  Hi,

   When u load data intitially in to datawarehouse it will be Full Load.

   If u r loading data everyday in to datawarehouse it will be incremental load

   Thanks,

   Ram