Property |
Value |
Database schema name |
dbo |
Database table name |
DimPromotion |
Friendly name |
Promotion |
Table name |
dbo_DimPromotion |
Table type |
Table |
Is loaded |
|
Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
FK_FactResellerSales_DimPromotion |
PromotionKey |
FactResellerSales |
Table |
PromotionKey |
FK_FactInternetSales_DimPromotion |
PromotionKey |
FactInternetSales |
Table |
PromotionKey |
FactSalesSummary-DimPromotion |
PromotionKey |
Sales Summary Facts |
View |
PromotionKey |
Total: 3 child relationship(s)
Name |
Type |
Computed column expression |
PromotionKey |
System.Int32 |
|
PromotionAlternateKey |
System.Int32 |
|
DiscountPct |
System.Double |
|
StartDate |
System.DateTime |
|
EndDate |
System.DateTime |
|
MinQty |
System.Int32 |
|
MaxQty |
System.Int32 |
|
EnglishPromotionName |
System.String |
|
SpanishPromotionName |
System.String |
|
FrenchPromotionName |
System.String |
|
EnglishPromotionType |
System.String |
|
SpanishPromotionType |
System.String |
|
FrenchPromotionType |
System.String |
|
EnglishPromotionCategory |
System.String |
|
SpanishPromotionCategory |
System.String |
|
FrenchPromotionCategory |
System.String |
|
DiscountPctDesc |
System.Double |
DiscountPct * 100 |
MaxQtyDesc |
System.Int32 |
CASE
WHEN MaxQty IS NULL THEN '0'
ELSE MaxQty
END |
SimpleEndDate |
System.String |
DATENAME(mm, EndDate) + ' ' +
DATENAME(dd, EndDate) + ', ' +
DATENAME(yy, EndDate) |
SimpleStartDate |
System.String |
DATENAME(mm, StartDate) + ' ' +
DATENAME(dd, StartDate) + ', ' +
DATENAME(yy, StartDate) |
Total: 20 column(s)