File Library

Data Warehousing in the Real World
Topic: Webinars
Owner: Kent Graziano
Date: 2016-12-01
Subtopic: Analytics

Kent Graziano, Snowflake Computing

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 we tie together using standard Hub and Link structures along with a Key Map table. While we have been 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. We will show you our solution and discuss the pros and cons of our approach. 

Download File   Kent Graziano Dec 1 BI.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database