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.
Tag Archives: EDW
Data Vault And Staging Area
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.
DV modeling for CLOB, LOB, BIN, IMAGE…
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.
Sequence Numbers – for EDW & BI projects
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.