Generate the Data Definition Language for Oracle Business Analytics Warehouse

Deploy the customization changes of Oracle Business Analytics Warehouse into the warehouse schema of Oracle BI Applications release 11.1.1.10.3 PS4 using the GENERATE_DW_DDL scenario.

See Generating the Oracle Business Analytics Warehouse DDL.

1. Launch ODI Studio and display the Designer navigator.
2. In the Projects editor, expand the Components, DW, Oracle, and Generate DW DDL folders.
3. Execute the GENERATE_DW_DDL scenario:

   Specify this information:

   Option	Description
   CREATE_SCRIPT_FILE	If set to True, this option creates a .sql file with the DDL script. The .sql file is useful to see the changes. If no value is provided for the SCRIPT_LOCATION option, then the procedure creates a file in the oracledi directory named biappsddl.sql.
   REFRESH_MODE	Use the INCREMENTAL mode. The INCREMENTAL mode compares the ODI data stores with the tables in the database. Use this option with the Table Mask option to speed up the comparison process of the entire data warehouse.
   CHARCLAUSE	Provided for Unicode support. If set to True, the CHAR clause is included in the DDL.
   RUN_DDL	If set to True, the DDL runs against your warehouse.
   SCRIPT_LOCATION	If you're creating a script, then this field indicates the path where the script is created.
   TABLE_MASK	Select the default % as it compares all tables. If you want to create the DDL for only a subset of tables or just a single table, then you can change this value. For instance, to create a different script for dimension tables, you can set this value to W_%_D.