Data Management Solutions Using SAS Hash Table Operations

Chapter 7: Supporting Data Warehouse Star Schemas

7.1 Introduction

7.2 Creating and Updating Fact Tables

7.3 Creating and Updating Slowly Changing Dimension Tables

7.3.1 Handling Type 0 Dimension Tables

7.3.2 Handling Type 1 Dimension Tables

7.3.3 Handling Type 2 Dimension Tables

7.3.4 Handling Type 3 Dimension Tables

7.3.5 Handling Type 4 Dimension Tables

7.3.6 Handling Type 6 Dimension Tables

7.4 Creating a Bizarro Ball Star Schema Data Warehouse

7.4.1 Defining the Data Warehouse Tables

7.4.2 Defining the Fact and Dimension Hash Tables via Metadata

7.4.3 Creating the Initial Data Structures for a Star Schema

7.4.4 Updating the Fact and Dimension Tables

7.5 Summary

7.1 Introduction

The Bizarro Ball business users and the data team have asked ...