The Smartest Way To Deal With The Data Integration Challenges
Authored by Dario Mangano
Edition: 1.0
Data Warehouse projects fail.
As an industry we have been battling with this phenomenon for decades. Though we have been getting better over the years, as an industry we still have a long way to go.
Fortunately some people have found ways to beat the odds. By thinking out of the box, formulating new ideas, and creating new innovative approaches these people have each somehow unlocked the secrets of successful DW programs.
How can I use natural language in my modeling process to achieve high-quality information models?
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.
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?
Page 2 of 7