EXTRACTION AND LOAD

Some of the problems associated with the extraction of data have already been described in this book. There are tools that might help with the extraction process, and the various types are described and discussed in Chapter 10.

There are two types of data load to be considered when designing a data warehouse:

  1. Initial load

  2. Incremental loads

Initial loading generally relates to circumstances rather than behavior. It includes the creation of customers, products, promotions, and geographic data such as branches and regions. The only time we need to consider the initial loading of behavior is in cases where there is some historical behavioral data to be loaded. Initial loading can be considered as a “one-off” exercise and does not ...

Get Designing a Data Warehouse: Supporting Customer Relationship Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.