GitHub3 天
Epsiode 3 - SQL Script - DIM_Products_MM.sql
ps.EnglishProductSubcategoryName AS [Sub Category], -- Joined in from Sub Category Table pc.EnglishProductCategoryName AS [Product Category], -- Joined in from Category Table ...
GitHub4 天
SQL Script - DIM_Products.sql
LEFT JOIN dbo.DimProductSubcategory AS ps ON ps.ProductSubcategoryKey = p.ProductSubcategoryKey LEFT JOIN dbo.DimProductCategory AS pc ON ps.ProductCategoryKey = pc.ProductCategoryKey ...