This content has been marked as final. Show 4 replies
We need to remove the right join below "ProductHistory" to load it as a table. Then, the slowly changing part should look like:
INNER JOIN Intervalmatch (OrderDate,ProductGroupID ) load StartDate,EndDate,ProductGroupID resident ProductHistory;
LEFT JOIN (Orders) LOAD * Resident ProductHistory;
DROP TABLE ProductHistory;
Thanks to those who gave me input!