This session was recorded live at Data Modeling Zone (www.DataModelingZone.com).
At a former health-care client, we were not able to implement a pure Data Vault 2.0 architecture. Instead, we had to evolve a hybrid solution that uses Type 2 persistent stage tables that we tie together using standard Hub and Link structures along with a Key Map table. While we were able to utilize DV 2.0 concepts such as MD5 hash keys, in order to avoid joins in loading the stage tables we had to come up with a way to resolve the Business Keys further into the process. In addition, we were able to build a business intelligence (BI) reporting layer using virtual dimensions that were hybrid type 1 and 2 combined. I will show you our solution with examples of real working code.