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...
- 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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
