July 2018
Beginner to intermediate
400 pages
12h 7m
English
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
The Bizarro Ball business users and the data team have asked ...