CREATE TABLE DimDate(
 DateKey INT IDENTITY(1,1) NOT NULL,
Source_ID int NULL,
First_Transaction date NULL,
Last_Transaction date NULL,
Promotion_Begin_Date date NULL,
Promotion_End_Date date NULL,
Month nvarchar(max) NULL);

-------------------------------

CREATE TABLE DimLocation(
 LocationKey INT IDENTITY(1,1) NOT NULL,
Source_ID int NULL,
Region nvarchar(max) NULL,
location nvarchar(max) NULL,
Region2 nvarchar(max) NULL,
Address nvarchar(max) NULL,
zipcode int NULL);
------------------------------------

CREATE TABLE DimCustomer
(CustomerKey INT IDENTITY(1,1) NOT NULL,
  Source_ID int NULL,
customer_id nvarchar(max) NULL,
Gender nvarchar(max) NULL,
Age INT NULL);

---------------------------
CREATE TABLE DimProduct
(ProductKey INT IDENTITY(1,1) NOT NULL,
  Source_ID int NULL,
product_name nvarchar(max) NULL,
brand_name nvarchar(max) NULL,
product_category nvarchar(max) NULL,
retailer nvarchar(max) NULL,
description nvarchar(max) NULL,
style_attributes nvarchar(max) NULL,
total_sizes nvarchar(max) NULL,
available_size nvarchar(max) NULL,
color nvarchar(max) NULL);


CREATE TABLE DimStore
(StoreKey INT IDENTITY(1,1) NOT NULL,
  Source_ID int NULL,
Store_id int NULL,
sitename nvarchar(max) NULL);

----------------------------------------
CREATE TABLE DimPromotion
(PromotionKey INT IDENTITY(1,1) NOT NULL,
  Source_ID int NULL,
Promotion_Type nvarchar(max) NULL,
Promotion_ID int NULL);

--------------------------------------