-
Notifications
You must be signed in to change notification settings - Fork 0
/
DIM_CUSTOMER.sql
37 lines (37 loc) · 1.16 KB
/
DIM_CUSTOMER.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
--Cleansed DIMCustomer table---
SELECT c.CustomerKey AS [Customer Key]
--,[GeographyKey]
--,[CustomerAlternateKey]
--,[Title]
,c.firstName as [FirstName]
--,[MiddleName]
,c.lastname as [LastName]
,c.FirstName + ' ' + c.LastName AS [Full Name]
--,[NameStyle]
--,[BirthDate]
--,[MaritalStatus]
--,[Suffix]
,CASE c.Gender WHEN 'M' THEN 'Male' WHEN 'F' THEN 'Female' END AS Gender
--,[EmailAddress]
--,[YearlyIncome]
--,[TotalChildren]
--,[NumberChildrenAtHome]
--,[EnglishEducation]
--,[SpanishEducation]
--,[FrenchEducation]
--,[EnglishOccupation]
--,[SpanishOccupation]
--,[FrenchOccupation]
--,[HouseOwnerFlag]
--,[NumberCarsOwned]
--,[AddressLine1]
--,[AddressLine2]
--,[Phone]
,c.datefirstpurchase AS [DateFirstPurchase]
--,[CommuteDistance]
,g.city AS [Customer City]
FROM [AdventureWorksDW2022].[dbo].[DimCustomer] AS c
LEFT JOIN [AdventureWorksDW2022].[dbo].[DimGeography] AS g
ON g.GeographyKey = c.GeographyKey
ORDER BY
CustomerKey ASC --Ordered by Customer Key