Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks so much!
Best,
Kiru
Hi,
Please check the article that HIC wrote about this.
IntervalMatch and Slowly Changing Dimensions
Cheers
Prasan