A pattern for Data Mart delivery
I’ve just completed a new article that outlines a solid approach to
to deliver (generate) a Data Mart on top off a Data Vault.
At least that’s what I think!
I’m always open for discussions, so please contact me for questions and / or feedback.
The document is the result of many discussions and tests, and really makes a case for the ‘insert-only’ Data Vault. It also covers how Data Vault can elegantly manage different timelines and handle late-arriving data while maintaining auditability.
Many thanks to Dan Linstedt, Tom Breur and Christian Haedrich for taking the time to providing feedback – really appreciated! And also of course thanks to Scott Diprose for the Table Valued tweaks (and your patience).
Don’t forget, if you’re in Europe have a look at the 3-day implementation training in Berlin, Germany (25th-27th of February – delivered in English!). It’s going to be great! We are also planning some additional (free) hands-on workshops to experiment with topics such as these.
More information is available on www.virtualdwh.de.