Regarding IntervalMatch function for slowly changing dimensions
Hello Friends,
Kindly let me know the solutions for the interval match issue below. Actually I have 4 tables,
SalesOrderHeader:
SQL SELECT
OrderDate,
TerritoryID,
SalesOrderID
FROM SalesOrderHeader;
SalesTerritoryHistory:
SQL SELECT BusinessEntityID as EmployeeBusinessEntityID,
EndDate,
StartDate,
TerritoryID
FROM SalesTerritoryHistory;
Employee:
SQL SELECT
EmployeeBusinessEntityID,
EndDate as Employee_EndDate,
FirstName,
StartDate as Employee_StartDate
FROM Employee;
SalesOrderDetail:--This is my transaction table
SQL SELECT
OrderQty,
ProductID,
SalesOrderDetailID,
SalesOrderID,
UnitPrice,
UnitPriceDiscount
FROM SalesOrderDetail;
I tried creating interval match function to link the Orderdate in SalesOrderHeader with intervals in SalesTerritoryHistory but it is not working as expected, I need to show the Sales metrics of employees, kindly let me know your solutions.I have attached the datamodel for your reference.
