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

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