Chapter 3: Designing a Data Warehouse

 < Day Day Up > 



Overview of Warehouse Design

The following figure shows how SAS ETL Studio is used to flow data into and out of a central data warehouse.

click to expand
Figure 3.1: Best Practice Data Warehouse

In this model, SAS ETL Studio jobs are used to perform the following tasks:

  1. Extract enterprise data into a staging area.

  2. Cleanse and validate data and load a central data warehouse.

  3. Populate a data mart or dimensional model that provides collections of data from across the enterprise.

Each step of the enterprise data model is implemented by multiple jobs in SAS ETL Studio. Each job in each step can be scheduled to run at the time or event that best fits your business needs and network performance requirements.



 < Day Day Up > 



SAS Institute - SAS 9.1.3 ETL Studio. User's Guide
SAS 9.1.3 ETL Studio: Users Guide
ISBN: 1590476352
EAN: 2147483647
Year: 2004
Pages: 127
Authors: SAS Institute

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net