Q&A:Perform Impact Analysis on Relationship Changes

here we look at impact analysis of business changes, relationship changes and what it does to the data vault model.  if you have comments, thoughts, or other experiences i encourage you to add your comment to the end of this posting.   as you know, i’ve launched one-on-one coaching, this is the kind of knowledge you get within the walls of one-on-one coaching. but for today  – i’m giving you the answers free to show you the kind of value you get when you sign up for my coaching sessions.  contact me today: coach@danlinstedt.com for more information.

how do you perform impact analysis on reports when relationship definitions change?

answer: you don’t need to!!  the beauty of changing relationship definitions is that the data vault is data driven. what that means is: when the relationship changes, the data set coming in to the dv changes.  it does not impact the model at all.  zero re-engineering.  now, if the business is concerned about tracking the relationship (ie: metrics – how often is it broken, when is it broken, what does the data look like when it’s broken, where does the broken data come from, etc..) they can choose to implement the business rules (yes, relationship tracking is a business rule!!!) in the etl going from the data vault downstream to the data marts. 

once again: maximum flexibility.  by the way, the first thing that breaks “traditional data warehouses” is the enforcement of today’s relationships at the data model level… just think about it – what happens when you “model” data relationships into a data warehouse for one source system, then begin to load either history data, or a second or third source systems’ data set????   the relationship enforcement breaks causing re-engineering.

you want the secret don’t you?  ok, here it is…  this one is “on the house…”

this simply is not the case with the data vault… come one, come all – all data is accepted all the time regardless of relationship with other data sets.  many-to-many means the data vault can accept all data from all systems, historical or future – without changes!!

Tags: ,

No comments yet.

Leave a Reply