| Publisher | SAS Institute | ||
|---|---|---|---|
| Format | 470.5KB PDF | Date added | 28 Feb 2006 |
| Topics | Data Acquisition - ETL, Business Intelligence - Data Warehousing | ||
| Downloads | 25 | ||
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.
Did you find this white paper useful?
28 out of 50 users found this white paper useful
Related white papers
Predictive Analytics for the Claim Handling Process
Predictive Analytics for the Claim Handling Process: Understanding the Analytics Behind Predictive Claims This 12-page technical brief serves as a guide for understanding how Predictive Claims' predictive modeling capabilities can...
Visualizing Irish Banter
Discussion forums could benefit from an exploratory search capability. The large quantity of information on discussion forums can present an opportunity for helping a user through visualization. Self organizing maps...
Electro Generadora del Austro Centralizes Information and Accelerates Data Collection Time by 80%
ELECAUSTRO wanted to implement a scalable, robust, reliable IT infrastructure with easy-to-manage applications to support the company's growth and create a robust database to handle large volumes of transactions related...
Embry-Riddle Aeronautical University Cuts Annual Paper Usage and Greenhouse Emissions in Half
Embry-Riddle Aeronautical University wanted to eliminate duplication of student-related documents and process inefficiencies across 130 locations throughout the United States and Europe and establish a common application to house the...
Visual Display of Large Data Volumes
Many organizations have huge amounts of data, containing hundreds of millions of records. There are good solutions available for the purpose of collecting, organizing and consolidating data, but people still...
Have It Your Way: Rearrange and Replay Your Output With ODS DOCUMENT
Is everything about the SAS output the way one wants, except for the final order of the report objects? Does one want the output organized by year or by city,...
Getting Started with Master Data Management
What is Master Data Management (MDM)? How can it be used to drive the business, and why is it important for companies to understand and successfully manage their master data?...
