SHARE
TWEET

Untitled

a guest Aug 22nd, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- "Good code is its own best documentation." - Steve McConnell
  2. LOAD  dwh.DimProducts WITH SCD1
  3. SELECT
  4.   #ProductID,
  5.   Product.Name Product,
  6.   ProductCategory.name ProductCategory,
  7.   ProductSubCategory.name ProductSubCategory,
  8.   ProductNumber,
  9.   ProductModel.name ProductModel,
  10.   Color,
  11.   StandardCost,
  12.   ListPrice,
  13.   Size,
  14.   SizeUnitMeasureCode,
  15.   Weight,
  16.   WeightUnitMeasureCode,
  17.   ProductLine,
  18.   DiscontinuedDate,
  19.   MakeFlag,
  20.   FinishedGoodsFlag
  21. FROM staging.Product
  22. LEFT JOIN staging.ProductSubCategory USING ProductSubcategoryID
  23. LEFT JOIN staging.ProductCategory USING ProductSubCategory(ProductCategoryId)
  24. LEFT JOIN staging.ProductModel USING ProductModelID
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top