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

Quick Start with ODE v4

Sometimes developers don’t want to read much theory, they just too keen to start doing things and learn from the process. Here is a sample list of queries allowing to build your first ensemble with ODE in a few minutes. In this example we’ll create a...