Embracing Many-to-Many Relationships in Data Modeling: A Technical Guide PREFACE: there is another false belief out there: Many-to-many (links, pits, bridges) are bad and lead to join hell, and should never be used. WRONG…. want to know why? read on. Note: anyone who claims “LINKS ARE BAD” or “MANY-TO-MANY should never be used” needs to
Too many consultancies provide the following advice: Model your data warehouse with source system relationships, maintain source system referential integrity. In this article we will explore why: a) this is really bad advice, and b) leads to a rigid data warehouse requiring re-engineering when loading a new source. If you want to build a data
Thanks for reading. Subscribe to get the latest blogs, podcasts and notifications.
Embracing Many-to-Many Relationships in Data Modeling: A Technical Guide PREFACE: there is another false belief out there: Many-to-many (links, pits, bridges) are bad and lead to join hell, and should never be used. WRONG…. want to know why? read on. Note: anyone who claims “LINKS ARE BAD” or “MANY-TO-MANY should never be used” needs to…
Too many consultancies provide the following advice: Model your data warehouse with source system relationships, maintain source system referential integrity. In this article we will explore why: a) this is really bad advice, and b) leads to a rigid data warehouse requiring re-engineering when loading a new source. If you want to build a data…