Months ago I talked to Stephan Volkmann, the student I mentor, about possibilities to write a seminar paper. One suggestion was to write about Information Modeling, namely FCO-IM, ORM2 and NIAM, siblings of the Fact-Orietented Modeling (FOM) family. In my opinion, FOM is the most powerful technique for building conceptual information models, as I wrote in a previous blogpost Sketch Notes Reflections at TDWI Roundtable with FCO-IM.

Data Vault Dimension-Ids

Resilient and temporally correct dimension Id’s for fact as well as dimension tables

In a dimensional data model based on a Data Vault data model, are integer values still necessary as dimension Id’s? And if so, how can the dimension Id’s be provided correctly?

A few weeks ago I received a surprisingly open and honest feedback on my recently published article "13 tips ...". I never ever expected that! After a short email exchange, I was allowed to publish the feedback anonymously. Below is the incredible feedback[3]. You see, you are not alone with the challenges of a Data Vault project:

Hi Dirk

Thanks for sending me the English version of the paper. I'm based in […] [1] and Data Vault is not generally established here yet.

Or how to successfully destroy every level of the data warehouse

Are you pampered with success and tired of the eternal pat on the back? You don't want to be so successful with your first attempt at implementing a Data Vault project that all your colleagues become jealous?

Subcategories