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

Big List of Standards

The sections below describe most of standards we have for Data Vault objects in the Optimal Data Engine. Whatever is on this web page is our current version. Databases ODE Data Vault solution will have at least three databases, configuration, stage and vault itself....

Databases and Schemas

ODE can be configured with a number of databases and schemas. Our standard approaches are as follows: MS SQL Server Our existing ODE deployments on SQL Server use several databases and schemas. ODE_Config ODE_Stage or ODE_Raw_Stage, with schema “stage”....

Reconciliation Testing ODE

When doing a data conversion between applications reconciliation testing is simple. Everything that was in the source application should be in the destination, and everything that is in the destination should be in the source. A data warehouse is a more complicated to...

Unit Test Pattern

Every program module that we write is paired with and preceded by several unit tests. To be explicit, unit tests are aligned to the code not to the features. Coverage Our unit tests cover every program module in the code with both a positive and a negative test....

Version Control Patterns

OptimalBI’s business plan for ODE is sophisticated, with both in-house and community aspects.  We also intend to maintain the product across a number of different platforms and at a variety of customer sites.  These many requirements motivate a using a...