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)