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.
Archive | Data Vault
RSS feed for this sectionAll things Data Vault
Maturity, Automation, Data Vault Standards Round 4
An executive viewpoint on why standards matter, and how you can optimize and mature your EDW / BI solution today.
Data Vault Standards Round 3
Another round in the arguments as to why standards are important. Again, if there is feedback, I welcome it.
Value of PIT and Bridge Tables in Data Vault 2.0
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.
Updates in Data Vault are DEAD! Finally
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
Reviewing Multi-Active Satellites
A short discussion on what a Multi-Active Satellite is and should be
#datavault 2.0 supports dynamic data warehousing
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…)
#datavault in 2016
A look at the Data Vault landscape for 2016, including WWDVC and a variety of enhancements that are happening around the world.
Generating #datavault models & Issues to address
Automated Data Vault Model Generation is NOT as easy as you think. Tool vendors DON’T yet have it right.
#datavault 2.0 and @MapR – install and setup
A quick technical look in to setting up VMWare configuration of MapR Drill and Data Vault 2.0 files