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,...

How To Create a Calculated Field in ODE v4

In ODE v4 we have introduced a new feature, we call it functions. Functions could be used in satellites to calculate attributes on the fly (during the load actually) from other satellite’s columns, i.e. calculated columns. At the moment most of the load logic is...

How To Implement Delta Load in ODE v4

ODE supports two types of data loads, Full load and Delta load. The difference is there are no deletions in Delta mode. So that Delta loads could be used for quick loads of small datasets as opposed to long overnight Full loads where full datasets are checked for new,...

Metrics Vault

Metrics Vault is a Data Vault for the data about the data. Metrics Vault is managed by ODE configuration database. It could be added to the Configuration at any time, and it will start collecting record stats, Vault data load time and record counts....