» » Hybrid Data Vault 2.0 Case Study: Data Warehousing in the Real World

Hybrid Data Vault 2.0 Case Study: Data Warehousing in the Real World

Tutorials   8-11-2018, 13:21   17   0   LeeAndro
Hybrid Data Vault 2.0 Case Study: Data Warehousing in the Real World
Hybrid Data Vault 2.0 Case Study: Data Warehousing in the Real World
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1.5 Hours | 1.12 GB
Genre: eLearning | Language: English

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.

DOWNLOAD
uploadgig


nitroflare


rapidgator


turbobit
Go Back
Your name: *
E-Mail:*
Bold Italic Underline Strike | Align left Center Align right | Insert smilies Insert link URLInsert protected URL Select color | Add Hidden Text Insert Quote Convert selected text from selection to Cyrillic (Russian) alphabet Insert spoiler
Security Code: *