-- "Good code is its own best documentation." - Steve McConnell
LOAD  dwh.DimProducts WITH SCD1
SELECT
  #ProductID,
  Product.Name Product,
  ProductCategory.name ProductCategory,
  ProductSubCategory.name ProductSubCategory,
  ProductNumber,
  ProductModel.name ProductModel,
  Color,
  StandardCost,
  ListPrice,
  Size,
  SizeUnitMeasureCode,
  Weight,
  WeightUnitMeasureCode,
  ProductLine,
  DiscontinuedDate,
  MakeFlag,
  FinishedGoodsFlag
FROM staging.Product
LEFT JOIN staging.ProductSubCategory USING ProductSubcategoryID
LEFT JOIN staging.ProductCategory USING ProductSubCategory(ProductCategoryId)
LEFT JOIN staging.ProductModel USING ProductModelID