Just what is this? You heard right… I’ve been able to absorb changes made to source system data models, and propogate them through to the right place in the Data Vault – AUTOMATICALLY. Now that’s a break-through. I’ve been working on this for quite a while, and finally achieved it tonight. It’s not complete, nor is it ready yet for prime-time, but it’s working – and from here it will only improve.
You’ve defined a target Data Vault, and someone gives you an updated source data model with new attributes/elements… not just one, but hundreds of changes. Perhaps they added comments, perhaps they changed the datatypes, lengths or precisions of some columns, perhaps they added or deleted columns… now it’s up to you (USUALLY BY HAND) to modify the target Data Vault model…
That could take you a couple days, or a couple weeks to roll out.
I’ve got it working now, to automatically push the changes through to the right place FOR you – takes only a few seconds to achieve…. Ok, there’s a few things behind it that make it work (that’s the magic I can’t share)…. but it works.
I believe this is a major breakthrough on the way to “Dynamic adjustments to the target data model” be it Data Vault target, or star-schema target, or even ODS (OLTP/3NF) target.
Dynamic Data Model Change Absorbtion is HERE… Now if I can just come up with a catchy name, anyone out there got a few ideas?
By the way, if you’re interested in this bit of software, drop me an email – I’ll be happy to talk to you about my plans for it, and see what you have in mind.