Modifying actions to get more from your diagrams
Actions are defined in Topology so that you can alter the DDLs that are generated by ODI from the model / Generate DDL menu command. A good understanding of the ODI Common Format Designer will help you before diving into this recipe.
Getting ready
A good starting point is Chapter 6, Working with Common Format Designer in the ODI developer's guide, available at http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/common_format.htm#CIHCBJJE.
How to do it...
In the Topology navigator, under the Physical Architecture tab, expand the Oracle technology. Then expand the Actions entry.
Right-click on Actions and select New Actions Group. Name the group
Oracle Cookbook
, save and close the Group definition window.Right-click on the Oracle Cookbook group that you have just created and select New Action. Name the action
Create table with comment
, set the Type value toCreate Table
, then click on the Details tab. We will create two lines for this action...