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.
All things Data Vault
An executive viewpoint on why standards matter, and how you can optimize and mature your EDW / BI solution today.
Another round in the arguments as to why standards are important. Again, if there is feedback, I welcome it.
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.
Automated Data Vault Model Generation is NOT as easy as you think. Tool vendors DON’T yet have it right.
A quick technical look in to setting up VMWare configuration of MapR Drill and Data Vault 2.0 files