Table: DimCustomer

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimCustomer 
 Friendly name   Customer 
 Table name   dbo_DimCustomer 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


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)

Collapse image Child relations


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)

Collapse image Columns


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)

Collapse image See also


About this documentation