UPDATE dbo.OnlineRetailStage
SET OnlineRetailStage.CustomerKey = DimCustomer.CustomerKey
FROM dbo.OnlineRetailStage
INNER JOIN DimCustomer
ON (OnlineRetailStage.Source_ID = DimCustomer.Source_ID);
----------------------------------


UPDATE dbo.OnlineRetailStage
SET OnlineRetailStage.DateKey = DimDate.DateKey
FROM dbo.OnlineRetailStage
INNER JOIN DimDate
ON (OnlineRetailStage.Source_ID = DimDate.Source_ID);

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

UPDATE dbo.OnlineRetailStage
SET OnlineRetailStage.LocationKey = DimLocation.LocationKey 
FROM dbo.OnlineRetailStage
INNER JOIN DimLocation
ON (OnlineRetailStage.Source_ID = DimLocation.Source_ID);

-----------------------------------------------
UPDATE dbo.OnlineRetailStage
SET OnlineRetailStage.ProductKey  = DimProduct.ProductKey 
FROM dbo.OnlineRetailStage
INNER JOIN DimProduct
ON (OnlineRetailStage.Source_ID = DimProduct.Source_ID);
---------------------------------------

UPDATE dbo.OnlineRetailStage
SET OnlineRetailStage.PromotionKey   = DimPromotion.PromotionKey 
FROM dbo.OnlineRetailStage
INNER JOIN DimPromotion
ON (OnlineRetailStage.Source_ID = DimPromotion.Source_ID);

------------------------------------
UPDATE dbo.OnlineRetailStage
SET OnlineRetailStage.StoreKey   = DimStore.StoreKey 
FROM dbo.OnlineRetailStage
INNER JOIN DimStore
ON (OnlineRetailStage.Source_ID =DimStore.Source_ID);

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