| 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)