SQL Tutorials – Basic Data Warehouse

Dimension tables – dim.orders

We continue to build out our data warehouse, this time with an order dimension table.

Resources

SQL to build dim.orders:

CREATE TABLE	superstore.dim.orders(
orderid 	VARCHAR(50) PRIMARY KEY
,customerid VARCHAR(25) NOT NULL
,shipmode	VARCHAR(50) NOT NULL
,segment	VARCHAR(50) NOT NULL
,stateprovince	VARCHAR(25) NOT NULL
,region		VARCHAR(50) NOT NULL
,countryregion	VARCHAR(25) NOT NULL
)
;
INSERT INTO	superstore.dim.orders
SELECT		orderid
			,customerid
			,shipmode
			,segment
			,stateprovince
			,region
			,countryregion
FROM		superstore.staging.orderitems
GROUP BY	orderid,customerid,shipmode,segment,stateprovince,region,countryregion
ORDER BY	orderid

SELECT *
FROM	superstore.dim.orders;