About Us

Home

Papers

Services

Links

Tools

Applied System Knowledge

Data Warehousing with the SAS® System

SAS and all other SAS Institute Inc. product or service names are registered trademarks of SAS Intitute Inc. in the USA and other countries. ® indicates USA registration.
SAS Institute world-wide can be found at www.sas.com and in the UK at www.sas.com/uk
You may also link directly to the SAS Data Integration technology pages

The Value of Metadata for ETL and Beyond

(SAS Forum UK, November 2004)

Metadata can be a great asset to a data warehouse – or just one more task to tick off the list. This paper outlines some of the ways to get value from your metadata assets and make the effort of recording it worthwhile.

Read the paper with slides

How Many Dates Do You Want? The Multiple Personality of Time in Your Data Warehouse

(Paper110, SUGI 29, Montreal, April 2004)
This paper discusses the many ways in which dates and time appear in a data warehouse, and seeks to explain why you might want to use – or to avoid – certain date constructs in your data warehouse.

Read the paper only or the paper with slides

A Sense of Perspective: How to use a Star Schema Data Warehouse to see any historical view you want.

(SeUGi 20 - Paris, France, June 2002)

Covering the reasons why history is needed in a data warehouse, and the different Time perspectives that may be required to support the business need for a "true" presentation of past data, this paper highlights some of the crucial techniques involved in building and querying a fully historical data store using extended Star Schema designs. A potential "ultimate star schema" with all possible viewpoints available is also discussed.

Read the paper only or the paper with slides