mobile-logo

Datawarehouse Architecture

Data Warehouse Automation Guide > Datawarehouse Architecture
20 Oct

Implementing a hash key collision strategy

by Hans Michiels
in Data Vault Series, Datawarehouse Architecture
Comments

Introduction Dan Linstedt, the inventor of Data Vault, has written a lot about it: hashkeys. For instance, one of his latest blog posts: #datavault 2.0, Hashes, one more time. I will not list all other sources, as you can use Google yourself. A few comments on hash keys: You need them for scalability. Using sequence numbers is taking the risk that your data warehouse does not scale well later when...

Read More
08 Jun

Using a Persistent Staging Area: What, Why, and How

by Hans Michiels
in Datawarehouse Architecture
Comments

Change log DateChanges 21 February, 2017Due to a very useful discussion on LinkedIn with Dan Linstedt, I have made some changes in this article to emphasize that a PSA does not have a permanent place in any EDW (with exception, as Dan suggests, being the Hadoop NoSQL platform used for slower storage mechanisms). Today I want to discuss the Persistent Staging Area in an Enterprise Data Warehouse, or PSA...

Read More