Short entry discussing some of the highlights of two specific Data Vault loading approaches.
Tag Archives: ELT
Q&A:Are there Hardware Dependencies for DV?
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.
Q&A:Additional tables impacting existing ETL jobs
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.
Q&A:Compare ETL Performance to Traditional Approach
This entry discusses the age-old-question of ETL performance – a Data Vault approach and a Traditional approach.
Q&A:What does the ETL for DV look like? Sample?
This post discusses in brief, what the ETL implementation for a Data Vault might look like.
OMB/OWB Code for Loading Satellites
Satellite Load Code example in Oracle Warehouse Builder (OMB) script.
OWB/OMB Script Annoyances – More!
Short excerpt on existing issues I’m finding, and incosistencies in the OMB/OWB product.
OWB / OMB Code Generated for Link Tables
OMB/OWB Data Vault Link Code generated from a couple simple inputs.
Oracle Warehouse Builder – OMB Script quirks
This is a look into tidbits of implementation for structures in OMB/OWB code.
Dynamic Data Modeling, Auto-Adaptation
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 […]