Snowflake:Getting Foreign Key Columns
A stored procedure to build and populate KEY_COLUMN_USAGE on Snowflake DB – because the database is currently missing this structure / view within the INFORMATION_SCHEMA.
Getting Data Out of a Data Vault is a Lot Easier Than Some People Think
By Dan Linstedt Data Vault Business Value One of my favorite topics to debate and discuss is how easy it is for business people to get …
Getting Data Out of a Data Vault is a Lot Easier Than Some People Think Read More »
Data Vault 2.0 – A Huge Advantage For Successful Mergers and Acquisitions
By Mark Budzinski The simple act of one firm buying the assets or stock of another firm is no longer a boardroom transaction hidden away from …
Data Vault 2.0 – A Huge Advantage For Successful Mergers and Acquisitions Read More »
Normalization and Denormalization in Data Models
Hi Everyone, Recently I heard about the CDVP2 hands-on materials, and the CDVP2 materials were not representing normalization or denormalization in the right light. I wanted …
Normalization and Denormalization in Data Models Read More »
Effectivity Sats and Second Level Stages
This week I bring you a few definitions, and some interesting questions and answers that I’ve had over the years. We teach these concepts in our …
Understanding Late Arriving Data
Call it back-dated data, call it real-time feeds, call it old data arriving late, call it what you will. The problem has persisted since day 1 …
Technical Tip: Clustered Hash Keys – Don’t Do it!
This is a short tip for everyone out there implementing Data Vaults. We’ve heard throughout the years about people trying to CLUSTER the Hash Keys in …
Technical Tip: Clustered Hash Keys – Don’t Do it! Read More »
