Clear all

Question from our Data Vault 2.0 Book

Posts: 469
Topic starter
Joined: 2 years ago

Here is a question I received via email, about the book.  I've provided my thoughts as an answer below.

I am big fan of your Data Vault concepts, currently i am trying by reading your book "Building a Scalable data warehouse with Data Vault 2.0". i have a questions regarding data integrations(Multiple source) in Business data vault. is it possible to integrate two different business sources in to one view/table in business data vault which are not actually related business wise, for example I have policy_Number, contract_Date , contract_enddate from Property_Casuality Insurance and the same set attributes from life Insurance , they are totally different business , is it possible to put them together in business data vault ?

Thanks for being a fan!  I really appreciate it 🙂   I have taken the liberty of posting the answer here, so that everyone can see my response.

1. Is it possible to integrate multiple sources in to one view/table in a business data vault that are not actually related business wise?

Yes. in a business data vault you can relate any data you see fit.  And as usual, just like "conforming a type 2 dimension" - it will require a solid knowledge of business rules.  This is no different than conforming data for a type 2 dimension

Hope this helps,