/*
Create database StagingDB
Go
*/

IF EXISTS
      (SELECT *
         FROM sys.objects
        WHERE     object_id = OBJECT_ID (N'[dbo].[DimCustomer]')
              AND type IN (N'U'))
DROP TABLE [dbo].[DimCustomer]

IF EXISTS
      (SELECT *
         FROM sys.objects
        WHERE     object_id = OBJECT_ID (N'[dbo].[CustomerStaging]')
              AND type IN (N'U'))
DROP TABLE [dbo].[CustomerStaging]


CREATE TABLE dbo.DimCustomer (
   CustomerID INT
         IDENTITY 
         NOT NULL,
   CustomerKey INT NULL,                                        -- BusinessKey
   CustomerName VARCHAR (50) NULL,
   Planet VARCHAR (50) NULL,
   Affiliation VARCHAR (50) NULL)
GO

CREATE TABLE dbo.CustomerStaging (
  CustomerID INT
         IDENTITY 
         NOT NULL,
   CustomerKey INT NULL,                                        -- BusinessKey
   CustomerName VARCHAR (50) NULL,
   Planet VARCHAR (50) NULL,
   Affiliation VARCHAR (50) NULL)
GO



INSERT INTO dbo.DimCustomer (CustomerKey,
                             CustomerName,
                             Planet,
                             Affiliation)
   VALUES (1, 'Anakin Skywalker', 'Tatooine', 'None'),
          (2, 'Yoda', 'Coruscant', 'Jedi'),
          (3, 'Obi-Wan Kenobi', 'Coruscant', 'Jedi')

INSERT INTO dbo.CustomerStaging (CustomerKey,
                                 CustomerName,
                                 Planet,
                                 Affiliation)
   VALUES (2, 'Master Yoda', 'Coruscant', 'Jedi'),
          (3, 'Obi-Wan Kenobi', 'Tatooine', 'Jedi'),
          (4, 'Darth Vader', 'Coruscant', 'Sith')


Select * From  DimCustomer
Select * From  CustomerStaging