fbpx

Querying Star Schemas

This page serves as a reference for my course “Star Schema Foundations” Module 9 – Querying Star Schemas

Querying a Single Dimension

— everything is just 1 join away

select *
from FactSalesOrderDetail f
join DimProduct p on f.DimProductID = p.DimProductID

 

Querying Multiple Dimensions


select *
from FactSalesOrderDetail f
join DimProduct p on f.DimProductID = p.DimProductID
join DimCustomer c on f.DimCustomerID = c.DimCustomerID
join DimDate d on f.DimDateID = d.DimDateID

 

Creating a View


create view vwSalesDetails as (
select ...
from FactSalesOrderDetail f
join DimProduct p on f.DimProductID = p.DimProductID
join DimCustomer c on f.DimCustomerID = c.DimCustomerID
join DimDate d on f.DimDateID = d.DimDateID
)