Using ODI versioning

Versioning source code is a key element for a successful development lifecycle. All ODI objects can be exported as XML files if you want to store them in an external source control system, but one limitation of this approach is that the comparison of different versions of the same objects are not trivial in the XML form.

To make version comparisons easier, you can leverage versioning of objects directly within ODI. This recipe will show you how to take advantage of this feature.

Getting ready

To play with versioning, we will need some objects. You can use any objects of your choice, but for our step-by-step instructions, we will first create an interface based on the SRC_EMP and TRG_EMP tables as described in the Preface of this book.

To follow the steps described here, do the following:

• If you have not done so earlier, create a model where you reverse engineer the SRC_EMP table from our source sample.

• If you have not done so earlier, create a model where you reverse engineer...