--2.4.1
SELECT ss.TransactionID
    , ss.TransactionDetailID
    , dt.TimeID
    , soh.TerritoryID
    , ss.ProductID
    , soh.CustomerID
    , ss.UnitPrice
    , ss.OrderQty AS Quantity
    , ss.LineTotal AS TotalValue
    , ss.UnitPriceDiscount
    , ss.TotalDiscountValue
INTO AS220655.DWL3.SalesData
FROM Sales.SalesOrderHeader soh
JOIN AS220655.DWL3.SimpleSales ss
ON soh.SalesOrderID=ss.TransactionID
JOIN AS220655.DWL3.DIMTime dt
ON dt.TimeID=CONCAT(DATEPART(yyyy,soh.OrderDate), RIGHT('00' + CONVERT(NVARCHAR(2), DATEPART(MONTH, soh.OrderDate)), 2), RIGHT('00' + CONVERT(NVARCHAR(2), DATEPART(DAY, soh.OrderDate)), 2));

ALTER TABLE [AS220655].DWL3.SalesData ADD CONSTRAINT PK_SalesData PRIMARY KEY(TransactionID, TransactionDetailID);
ALTER TABLE [AS220655].DWL3.SalesData ADD CONSTRAINT FK_SalesData_TimeID FOREIGN KEY(TimeID) REFERENCES [AS220655].DWL3.DIMTime(TimeID);
ALTER TABLE [AS220655].DWL3.SalesData ADD CONSTRAINT FK_SalesData_ProductID FOREIGN KEY(ProductID) REFERENCES [AS220655].DWL3.DIMProduct(ProductID);