mattcasters commented on issue #8803: URL: https://github.com/apache/hop/issues/8803#issuecomment-6056669389
Add a mention of the possibility to link a fact table to both the correct SCD2 record that captures all changes you want to track AND to an SCD1 dimension that you built. It gives you hybrid functionality for analytics at the cost of an extra column in the fact and an extra table to manage. In a lot of cases, that SCD1 table can be a view on the SCD2 (`WHERE now() BETWEEN from_ts AND to_ts`) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
