Property |
Value |
Database schema name |
dbo |
Database table name |
DimProduct |
Friendly name |
Product |
Table name |
dbo_DimProduct |
Table type |
Table |
Is loaded |
|
Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
FK_DimProduct_DimProductSubcategory |
ProductSubcategoryKey |
DimProductSubcategory |
Table |
ProductSubcategoryKey |
DimProduct-DimProductSubcategory |
ProductSubcategoryKey |
DimProductSubcategory |
Table |
ProductSubcategoryAlternateKey |
Total: 2 parent relationship(s)
Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
FK_FactResellerSales_DimProduct |
ProductKey |
FactResellerSales |
Table |
ProductKey |
FK_FactInternetSales_DimProduct |
ProductKey |
FactInternetSales |
Table |
ProductKey |
FactSalesSummary-DimProduct |
ProductKey |
Sales Summary Facts |
View |
ProductKey |
Total: 3 child relationship(s)
Name |
Type |
Computed column expression |
ProductKey |
System.Int32 |
|
ProductAlternateKey |
System.String |
|
ProductSubcategoryKey |
System.Int32 |
|
WeightUnitMeasureCode |
System.String |
|
SizeUnitMeasureCode |
System.String |
|
EnglishProductName |
System.String |
|
SpanishProductName |
System.String |
|
FrenchProductName |
System.String |
|
StandardCost |
System.Decimal |
|
FinishedGoodsFlag |
System.Boolean |
|
Color |
System.String |
|
SafetyStockLevel |
System.Int16 |
|
ReorderPoint |
System.Int16 |
|
ListPrice |
System.Decimal |
|
Size |
System.String |
|
SizeRange |
System.String |
|
Weight |
System.Double |
|
DaysToManufacture |
System.Int32 |
|
ProductLine |
System.String |
|
DealerPrice |
System.Decimal |
|
Class |
System.String |
|
Style |
System.String |
|
ModelName |
System.String |
|
LargePhoto |
System.Byte[] |
|
EnglishDescription |
System.String |
|
FrenchDescription |
System.String |
|
ChineseDescription |
System.String |
|
ArabicDescription |
System.String |
|
HebrewDescription |
System.String |
|
ThaiDescription |
System.String |
|
StartDate |
System.DateTime |
|
EndDate |
System.DateTime |
|
Status |
System.String |
|
ProductLineName |
System.String |
CASE ProductLine
WHEN 'M' THEN 'Mountain'
WHEN 'R' THEN 'Road'
WHEN 'S' THEN 'Accessory'
WHEN 'T' THEN 'Touring'
ELSE 'Components'
END |
WeightDesc |
System.String |
Case
WHEN Weight IS NULL THEN 'Unknown'
ELSE CONVERT(CHAR (5), Weight)
END |
SimpleStartDate |
System.String |
DATENAME( mm, StartDate ) + ' ' +
DATENAME( dd, StartDate ) + ', ' +
DATENAME( yy, StartDate ) |
SimpleEndDate |
System.String |
CASE
WHEN EndDate IS NULL THEN 'Active'
ELSE
DATENAME(mm, EndDate) + ' ' +
DATENAME(dd, EndDate) + ', ' +
DATENAME(yy, EndDate)
END |
StatusDesc |
System.String |
CASE
WHEN Status IS NULL THEN 'Historical'
ELSE Status
END |
StyleDesc |
System.String |
CASE
WHEN Style IS NULL THEN 'Not Applicable'
WHEN Style = 'U' THEN 'Unisex'
WHEN Style = 'M' THEN 'Mens'
WHEN Style = 'W' THEN 'Womens'
END |
ClassDesc |
System.String |
CASE
WHEN Class IS NULL THEN 'Not Applicable'
WHEN Class = 'H' THEN 'High'
WHEN Class = 'M' THEN 'Medium'
WHEN Class = 'L' THEN 'Low'
END |
GermanDescription |
System.String |
|
JapaneseDescription |
System.String |
|
TurkishDescription |
System.String |
|
ModelNameAssembly |
System.String |
Case
WHEN ModelName IS NULL THEN 'Assembly Components'
ELSE ModelName
END |
Total: 44 column(s)