Lengthy questions about the canonical structure, conceptual vs physical data vault modeling, Raw Data Vault vs business applications. An interesting read, please add your own comments to the end of this posting.
I dive into some of the issues of using a Data Vault model as a staging area, and why you might want to re-consider this as an invalid approach.
Ever wanted to know what to do with binary, image, and other unstructured data in the Data Vault? This post discusses how to properly model these components to make it work going forward.
In this post I talk about sequence numbers, what they are and why they should stay “hidden” in the databases in which they are created.