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.
Another round in the arguments as to why standards are important. Again, if there is feedback, I welcome it.
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
[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text”] (more…)
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.