Create a Data Vault with ODE v5

ODE is available as a download from GitHub, which has the instructions for imlmenting the Configuration Database. Configuration is a heart and brain of ODE Data Vault. Other organs include stage and vault databases. From ODE version 5 these databases should have a...

Satellite Change Data Capture Functions

In the Data Vault satellite is a container for business concept’s attributes and it has a SCD type 2 structure for storing the data. This means that history of record changes is stored in the satellite alongside with its current state. One have to use a set of...

How To Monitor and Troubleshoot Data Loads?

How to Monitor? You can set up a scheduled email to be sent to an administrator or to a group of administrators responsible for monitoring the Data Vault loads. ODE sends an email on procedure [dv_scheduler].[dv_report_email_manifest_progress] execution. SQL...

How To Reconcile Tables Using ODE v4

One of the new features of ODE version 4 is built-in reconciliation. This feature can be used to compare any two objects in the Data Vault including staging tables. So you can compare two satellites, or stage table and satellite, or two links, or any other combination...

How To Version Business Rules in ODE v4

ODE attaches all Processing Rules to “Source Tables”. Each Source Table can have a number of Source Table Versions, only one of which may be “Current”. The rest are retained for history and tracking purposes. As data is loaded into the Vault,...