O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Generating DDL from data models

For each and every data store represented within a given data model, ODI has the ability to generate a procedure containing the Data Definition Language (DDL) statement needed by the associated technology to create that object. This feature provides an expedient and effective way to automatically create procedures that can be used within a package workflow to manage the creation of any data store object.

Getting ready

The purpose of this recipe is to demonstrate DDL generation. To follow along, you will only need to have imported the DEMO_SRC and DEMO_TRG data models as described in the Preface.

How to do it...

  1. From the Designer tab, expand the Models section and right-click on the DEMO_TRG data model. Select the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required