White Papers

Stars and Models: How to Build and Maintain Star Schemas Using SAS Data Integration Server in SAS9

Overview 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.

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher: SAS Institute
File Format: PDF
Date Published: Dec 22, 2006
Format: White Papers
Topics: Data Acquisition - ETL, Business Intelligence - Data Warehousing

Similiar White Papers

American Airlines uses Sybase IQ to conduct fast ad hoc queries to uncover fraudulent ticketing.

American Airlines is the world?s largest carrier, serving more than 250 cities in 41 countries with 1,100 airplanes and

Publisher: Sybase | Tags: data

Managing ETL Processes

ETL tools allow the definition of sometimes complex processes to extract, transform, and load heterogeneous data into a

Publisher: Association for Computing Machinery | Tags: data, data integration, data warehouse, management

Understanding the System Architecture of SAS/ETL and SAS/EBI Server for Federal Enterprise Architecture Requirements

This paper describes some of the key points learned through: many conversations with SAS Institute, and persistence to u

Publisher: SAS Institute | Tags: infrastructure, software

Climbing to the OLAP Summit With Oracle Warehouse Builder 10gR2

The aim of this whitepaper is to review how Oracle Warehouse Builder 10gR2 can help companies successfully implement new

Publisher: Oracle | Tags: data, data warehouse, database, management, server, unified, warehouse

Bust a Move with Your SSIS - Passing Package Variables

Integration Services (SSIS), the next generation of the Extract, Transport, and Load (ETL) feature included with Microso

Publisher: Global Knowledge | Tags: data

SAS Institute White Papers

A Clever Demonstration of the SAS SUBSTR Function

The SAS SUBSTR function differs from the substring function in other programming languages as it can be used on either s

Publisher: SAS Institute

Understanding Your Customer: Segmentation Techniques for Gaining Customer Insight and Predicting Risk in the Telecom Industry

The explosion of customer data in the last twenty years has increased the need for data mining aimed at Customer Relatio

Publisher: SAS Institute | Tags: crm, customer service, data, data mining

Featured white papers

The Value of Location Intelligence in the Communications Industry

Pitney Bowes

Public Services are under pressure, the challenge is to do more with less. How do you improve citizen satisfaction, increase cost efficiencies and improve service delivery? The power of location intelligence is helping many local authorities...

Download now »
Best Practices for Translating Customer Satisfaction into Revenue

Citrix Online

Today's support organisations are focused on two top-level metrics: financial results and customer satisfaction. For most, it's easy to track financial performance, but customer satisfaction is akin to speaking a foreign language...

Download now »
HP print solutions and 3M

Hewlett-Packard (HP)

The objective for 3M was to optimize office printing infrastructure at 3M locations worldwide, reduce total cost and environmental footprint. Some of the business benefits acheived by switching to HP print solutions...

Download now »