A walk back through the joins, hashing, Teradata, key selection, and arguments for and against sequence numbers. While this post is specifically related to Teradata, there are some generic statements here that apply to all MPP solutions.
An executive viewpoint on why standards matter, and how you can optimize and mature your EDW / BI solution today.
A short look at why the Data Vault standards are the way they are.
A quick entry about the value and positioning of PIT and Bridge Tables in virtualizing data marts, providing equal joins against the DV model, and improving join performance against the Data Vault 2.0 solution.
A quick/ short entry discussing the end of Load End Dates and Last Seen Dates. Finally, the removal of all UPDATE processes in your EDW / Data vault 2.0
A short discussion on what a Multi-Active Satellite is and should be
It’s been a while since I blogged about features and functionality of the Data Vault, but here is an entry that discusses something I’ve been talking about since 2001. Dynamic Data Warehousing. This is the next step beyond active data warehousing / operational data vaults. (more…)
A look at the Data Vault landscape for 2016, including WWDVC and a variety of enhancements that are happening around the world.
A quick technical look in to setting up VMWare configuration of MapR Drill and Data Vault 2.0 files
datavault boot camp and private certification in Saint Albans, Vermont in October 2015