ETL - What is Full load & Incremental or Refresh load?

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 22 of 60

What is Full load & Incremental or Refresh load?

Total Answers and Comments: 4

Last Update: February 28, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 29, 2005 08:58:38

Nidhi

RE: What is Full load & Incremental or Refresh load?

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.

Is this answer useful? Yes | No

August 17, 2005 05:50:00

Rupesh Shah

RE: What is Full load & Incremental or Refresh load?

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.

Is this answer useful? Yes | No

August 23, 2005 17:25:45

Sriharsha Hanumanth

RE: What is Full load & Incremental or Refresh load?

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.

Is this answer useful? Yes | No

February 28, 2006 04:14:10

Ram

RE: What is Full load & Incremental or Refresh load?

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

Is this answer useful? Yes | No

Go To Top