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)