| Property |
Value |
| Database schema name |
dbo |
| Database table name |
DimReseller |
| Friendly name |
Reseller |
| Table name |
dbo_DimReseller |
| Table type |
Table |
| Is loaded |
|
| Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
| FK_DimReseller_DimGeography |
GeographyKey |
DimGeography |
Table |
GeographyKey |
Total: 1 parent relationship(s)
| Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
| FK_FactResellerSales_DimReseller |
ResellerKey |
FactResellerSales |
Table |
ResellerKey |
Total: 1 child relationship(s)
| Name |
Type |
Computed column expression |
| ResellerKey |
System.Int32 |
|
| GeographyKey |
System.Int32 |
|
| ResellerAlternateKey |
System.String |
|
| Phone |
System.String |
|
| BusinessType |
System.String |
|
| ResellerName |
System.String |
|
| NumberEmployees |
System.Int32 |
|
| AddressLine1 |
System.String |
|
| AddressLine2 |
System.String |
|
| AnnualSales |
System.Decimal |
|
| BankName |
System.String |
|
| MinPaymentType |
System.Byte |
|
| MinPaymentAmount |
System.Decimal |
|
| AnnualRevenue |
System.Decimal |
|
| YearOpened |
System.Int32 |
|
| OrderFrequency |
System.String |
|
| OrderMonth |
System.Byte |
|
| FirstOrderYear |
System.Int32 |
|
| LastOrderYear |
System.Int32 |
|
| ProductLine |
System.String |
|
| OrderFrequencyDesc |
System.String |
CASE
WHEN OrderFrequency = 'A' THEN
'Annual'
WHEN OrderFrequency = 'S' THEN
'Bi-Annual'
ELSE
'Quarterly'
END |
| OrderMonthDesc |
System.String |
CASE
WHEN OrderMonth = '1' THEN
'January'
WHEN OrderMonth = '2' THEN
'February'
WHEN OrderMonth = '3' THEN
'March'
WHEN OrderMonth = '4' THEN
'April'
WHEN OrderMonth = '5' THEN
'May'
WHEN OrderMonth = '6' THEN
'June'
WHEN OrderMonth = '7' THEN
'July'
WHEN OrderMonth = '8' THEN
'August'
WHEN OrderMonth = '9' THEN
'September'
WHEN OrderMonth = '10' THEN
'October'
WHEN OrderMonth = '11' THEN
'November'
WHEN OrderMonth = '12' THEN
'December'
ELSE 'Never Ordered'
END |
| FirstOrderYearDesc |
System.String |
CASE
WHEN NOT FirstOrderYear IS NULL THEN
CONVERT(varchar,FirstOrderYear)
ELSE 'Never Ordered'
END |
| LastOrderYearDesc |
System.String |
CASE
WHEN NOT LastOrderYear IS NULL THEN
CONVERT(varchar,LastOrderYear)
ELSE 'Never Ordered'
END |
| MinPaymentTypeDesc |
System.String |
CASE
WHEN MinPaymentType = '1' THEN
CONVERT(varchar, 'No Minimum')
WHEN MinPaymentType = '2' THEN
CONVERT(varchar, 'Percent')
WHEN MinPaymentType = '3' THEN
CONVERT(varchar, 'Amount')
ELSE 'Unspecifed'
END |
| MinPaymentAmountDesc |
System.String |
CASE
WHEN NOT MinPaymentAmount IS NULL
THEN CONVERT(varchar, MinPaymentAmount)
ELSE 'Not Applicable'
END |
Total: 26 column(s)