ALTER TABLE factSales1
ADD CONSTRAINT FK_CustomerKey
FOREIGN KEY (CustomerKey)
references DimCustomer(CustomerKey);
-------------------------------------
ALTER TABLE factSales1
ADD CONSTRAINT FK_DateKey
FOREIGN KEY (DateKey)
references DimDate(DateKey);
-------------------------------
ALTER TABLE factSales1
ADD CONSTRAINT FK_LocationKey
FOREIGN KEY (LocationKey)
references DimLocation(LocationKey);

------------------------------
ALTER TABLE factSales1
ADD CONSTRAINT FK_ProductKey
FOREIGN KEY (ProductKey)
references DimProduct(ProductKey);

----------------------------------
ALTER TABLE factSales1
ADD CONSTRAINT FK_PromotionKey
FOREIGN KEY (PromotionKey)
references DimPromotion(PromotionKey);

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

ALTER TABLE factSales1
ADD CONSTRAINT FK_StoreKey
FOREIGN KEY (StoreKey)
references DimStore(StoreKey);