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

How To Implement Same-As Link

Same-as and hierarchical links represent recursive relationships. Same-as link let us know that two records in a Hub table both represent the same core concept. Hierarchical link let us know that there is a form of hierarchy  between two records in the same Hub...

Building a Data Vault with ODE v4

Data Vault with ODE Data Vault is a Data Warehousing methodology. Learn more about it here. ODE is a config-driven engine for building and managing Data Vaults. At the moment ODE only works with MS SQL Server. Refer here for the latest ODE installation. Modelling a...