| Property |
Value |
| Database schema name |
dbo |
| Database table name |
DimCustomer |
| Friendly name |
Customer |
| Table name |
dbo_DimCustomer |
| Table type |
Table |
| Is loaded |
|
| Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
| FK_DimCustomer_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_FactInternetSales_DimCustomer |
CustomerKey |
FactInternetSales |
Table |
CustomerKey |
Total: 1 child relationship(s)
| Name |
Type |
Computed column expression |
| CustomerKey |
System.Int32 |
|
| GeographyKey |
System.Int32 |
|
| CustomerAlternateKey |
System.String |
|
| FirstName |
System.String |
|
| MiddleName |
System.String |
|
| LastName |
System.String |
|
| NameStyle |
System.Boolean |
|
| BirthDate |
System.DateTime |
|
| MaritalStatus |
System.String |
|
| Suffix |
System.String |
|
| Gender |
System.String |
|
| EmailAddress |
System.String |
|
| YearlyIncome |
System.Decimal |
|
| TotalChildren |
System.Byte |
|
| NumberChildrenAtHome |
System.Byte |
|
| HouseOwnerFlag |
System.String |
|
| NumberCarsOwned |
System.Byte |
|
| AddressLine1 |
System.String |
|
| AddressLine2 |
System.String |
|
| Phone |
System.String |
|
| DateFirstPurchase |
System.DateTime |
|
| FullName |
System.String |
CASE
WHEN MiddleName IS NULL THEN
FirstName + ' ' + LastName
ELSE
FirstName + ' ' + MiddleName + '.' + ' ' + LastName
END |
| MaritalStatusDesc |
System.String |
CASE
WHEN MaritalStatus = 'S' THEN
'Single'
ELSE
'Married'
END |
| GenderDesc |
System.String |
CASE
WHEN Gender = 'M' THEN
'Male'
ELSE
'Female'
END |
| HouseOwnerDesc |
System.String |
CASE
WHEN HouseOwnerFlag = '1' THEN
'Yes'
ELSE
'No'
END |
| CommuteDistance |
System.String |
|
| CommuteDistanceSort |
System.String |
CASE
WHEN CommuteDistance= '0-1 Miles' THEN
'1'
WHEN CommuteDistance= '1-2 Miles' THEN
'2'
WHEN CommuteDistance= '2-5 Miles' THEN
'3'
WHEN CommuteDistance= '5-10 Miles' THEN
'4'
WHEN CommuteDistance= '10+ Miles' THEN
'5'
END |
| Title |
System.String |
|
| EnglishEducation |
System.String |
|
| SpanishEducation |
System.String |
|
| FrenchEducation |
System.String |
|
| EnglishOccupation |
System.String |
|
| SpanishOccupation |
System.String |
|
| FrenchOccupation |
System.String |
|
| SimpleDateFirstPurchase |
System.String |
DATENAME(mm, DateFirstPurchase) + ' ' +
DATENAME(dd, DateFirstPurchase) + ', ' +
DATENAME(yy, DateFirstPurchase) |
Total: 35 column(s)