Introduction As you might know, I started a survey on the usage and opinion about Data Warehouse Automation (DWA) Tools. Today I am presenting the results. I sincerely want to thank all the participants for sharing your thoughts. The participants First some insight into the persons that filled in the survey. You were not with so many (62 completed surveys). In statistics there is a formula to compute the minimum sample...
Read MoreChange 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 MoreIntroduction I must admit I have a weakness for British humour. When I had to cope with leading zeros in business keys some time ago, I spontaneously came up with the title of this post, not knowing that it would serve as such. For those who do not know, "Meetings, bloody meetings" is a British comedy training film in which John Cleese plays a main role. It was...
Read MoreIntroduction This weeks post is about the LoadDate and LoadEndDate. Actually there are two things to be nerdy on: End dating without gaps Getting the best value for bytes on DATETIME2 precision By the way, these topics apply to SQL Server, the examples are made using SQL Server 2014. 1. End dating without gaps How end dating works In a Data Vault Satellite, different subsequent versions of a row in the source...
Read MoreUpdates Change log DateChanges 31 January, 2017Really good news! The 8k limitation on HASHBYTES has been removed in SQL Server 2016! Today I would like to discuss Hash Diff calculation using SQL Server 2014, from my own experience. My purpose is NOT to be complete and/or to replicate book "Building a scalable data warehouse with Data Vault 2.0". For full details please read the book. However I will give a short...
Read More
