Jump to content

Data loading

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Bilal.zubairy (talk | contribs) at 05:50, 20 September 2007. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

The loading of the data in a warehouse is one of the most important process in developing a business intelligent software. In the staging area after the data has been extracted from the source system and transformed according to the target system the next step comes is to load the data in the warehouse.

There are three common techniques for data loading: 1. Full data refresh. 2. Incremental Load / refresh. 3. Trickle Feed.


Full Data Refresh:

In full data refresh, following steps are taken on target system(table):
a) Target table data is deleted.
b) All new data is loaded in the target from the source.

Incremental Load/Refresh:

In incremental refresh:
a) New and updated data is acquired from the source system.
b) The new data is appended to the existing data in the target system and the updated data is updated in the target system's existing data.


--Bilal.zubairy 05:50, 20 September 2007 (UTC)

Retrieved from "https://en.wikipedia.org/w/index.php?title=Data_loading&oldid=159113589"