Data loading: Difference between revisions

Revision as of 05:46, 20 September 2007

Revision as of 05:50, 20 September 2007

Line 1:

{{db-nocontext}}

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.

Line 13 ⟶ 12:

a) Target table data is deleted.<br />

b) All new data is loaded in the target from the source.

<br />

== Incremental Load/Refresh: ==

In incremental refresh:<br />

a) New and updated data is acquired from the source system.<br />

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.