Create table factSales(
SalesKey INT IDENTITY(1,1) NOT NULL,
CustomerSalesKey INT NULL,
DateKey INT NULL,
LocationKey INT NULL,
CustomerKey INT NULL,
ProductKey INT null,
StoreKey INT null,
PromotionKey INT null,
Source_ID int NULL,
tran_amount_2022 float NULL,
tran_amount_2023 float NULL,
tran_amount_2024 float NULL,
transactions_2022 float NULL,
transactions_2023 float NULL,
transactions_2024 float NULL,
 Sales float NULL,
mrp float NULL,
price float NULL,
rating float NULL,
review_count float NULL,
Order_NumerDD     int NULL,
Invoice_NumberDD  int NULL);
-----------------------

CREATE TABLE factSalesCustomer
(CustomerSalesKey INT IDENTITY(1,1) NOT NULL,
DateKey INT NULL,
 LocationKey INT NULL,
 CustomerKey INT NULL,
ProductKey INT null,
StoreKey INT null,
PromotionKey INT null,
Source_ID int NULL,
Annual_Income float NULL,
Spending_Score int NULL);