Short entry discussing some of the highlights of two specific Data Vault loading approaches.
There literally are NO hardware dependencies for using the Data Vault model, but you still might want to read this entry… I cover why, and expose a small bit of the databases and hardware underneath.
Here we discuss the impact of “additional tables” on ETL jobs. It really is negligable, but in this case – it would be good for you to read this entry.
This entry discusses the age-old-question of ETL performance – a Data Vault approach and a Traditional approach.
This post discusses in brief, what the ETL implementation for a Data Vault might look like.
Satellite Load Code example in Oracle Warehouse Builder (OMB) script.
Short excerpt on existing issues I’m finding, and incosistencies in the OMB/OWB product.
OMB/OWB Data Vault Link Code generated from a couple simple inputs.
This is a look into tidbits of implementation for structures in OMB/OWB code.
I’ve long held a belief that the Data Vault modeling style ushered in a new era, that being one where we have the power to dynamically accept and automatically absorb new data elements. Of course, as always there are some rules and regulations (patterns) around when and how this can happen, and when the modeling […]