DIM_Products

[Marina-ai-hub]

DIM_Products.csv

SQL Code:
-- Cleaned DIM_Products Table
SELECT p.[ProductKey]
, p.[ProductAlternateKey] AS ProductItemCode
-- ,[ProductSubcategoryKey]
-- ,[WeightUnitMeasureCode]
-- ,[SizeUnitMeasureCode]
, p.[EnglishProductName] AS [Product Name]
, ps.EnglishProductSubcategoryName AS [Sub Category]
, pc.EnglishProductCategoryName AS [Product Category]
-- ,[SpanishProductName]
-- ,[FrenchProductName]
-- ,[StandardCost]
-- ,[FinishedGoodsFlag]
, p.[Color] AS [Product Color]
--,[SafetyStockLevel]
--,[ReorderPoint]
-- ,[ListPrice]
, p.[Size] AS [Product Size]
--,[SizeRange]
-- ,[Weight]
-- ,[DaysToManufacture]
, p.[ProductLine] AS [Product Line]
-- ,[DealerPrice]
-- ,[Class]
-- ,[Style]
, p.[ModelName] AS [Product Model Name]
--,[LargePhoto]
, p.[EnglishDescription] AS [Product Description]
-- ,[FrenchDescription]
-- ,[ChineseDescription]
-- ,[ArabicDescription]
-- ,[HebrewDescription]
-- ,[ThaiDescription]
-- ,[GermanDescription]
--,[JapaneseDescription]
-- ,[TurkishDescription]
-- ,[StartDate]
-- ,[EndDate]
, ISNULL (p.Status, 'Outdated') AS [Product Status]
FROM
[dbo].[DimProduct] as p
LEFT JOIN dbo.DimProductSubcategory AS ps ON ps.ProductSubcategoryKey = p.ProductSubcategoryKey
LEFT JOIN dbo.DimProductCategory AS pc ON ps.ProductSubcategoryKey = pc.ProductCategoryKey
ORDER BY p.ProductKey ASC