Loading...
Please wait, while we are loading the content...
Stars and Models : How to Build and Maintain Star Schemas Using SAS ® Data Integration Server in SAS ® 9
| Content Provider | Semantic Scholar |
|---|---|
| Author | Rausch, Nancy A. |
| Copyright Year | 2006 |
| Abstract | ABSTRACT Star schemas are used in data warehouses as the primary storage mechanism for dimensional data that is to be queried efficiently. Star schemas are the final result of the extract, transform, and load (ETL) processes that are used in building the data warehouse. Efficiently building the star schema is important, especially as the data volumes that are required to be stored in the data warehouse increase. This paper describes how to use the SAS Data Integration Server, which is the follow-on, next generation product to the SAS ETL Server, to efficiently build and maintain star schema data structures. A number of techniques in the SAS Data Integration Server are explained. In addition, considerations for advanced data management and performance-based optimizations are discussed. |
| File Format | PDF HTM / HTML |
| Alternate Webpage(s) | http://analytics.ncsu.edu/sesug/2006/TU07_06.PDF |
| Alternate Webpage(s) | http://www2.sas.com/proceedings/sugi31/096-31.pdf |
| Language | English |
| Access Restriction | Open |
| Content Type | Text |
| Resource Type | Article |
