r4MD44Tn

1USE [Cube]
2GO
3
4DROP TABLE IF EXISTS DimPerson;
5GO
6
7CREATE TABLE [dbo].[DimPerson](
8	[personID] [nvarchar](10) NOT NULL,
9	[personName] [nvarchar](50) NULL,
10	[birthYear] [int] NULL,
11	[birthDecade] [int] NULL,
12	[deathYear] [int] NULL,
13	[gender] [int] NULL,
14	[placeOfBirth] [nvarchar](50) NULL
15 CONSTRAINT [DimPersonPK] PRIMARY KEY CLUSTERED 
16(
17	[personID] ASC
18) ON [PRIMARY]
19) ON [PRIMARY]
20GO
21
22INSERT INTO DimPerson
23SELECT personID, personName, birthYear,
24birthYear/10 * 10,
25deathYear,
26gender,
27ISNULL(placeOfBirth, 'UNKNOWN')
28FROM IntermediateDB.dbo.Person;