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

Get Oracle Data Integrator 11g Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.