Design the Target Schema

In this section, you create and design the data objects for the Oracle target module. In previous steps, you may have already imported existing target objects.

To design the target schema: 

1. To create data objects, you can either start the appropriate wizard or use the Data Object Editor. To use a wizard, right-click the node for the desired object and select New. After using a wizard, you may want to modify the object in the editor. In that case, right-click the object and select Open Editor.

   For additional information, see Designing Target Schemas in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.

2. As you design objects, be sure to frequently validate the design objects.

   • You can validate objects as you create them, or validate a group of objects together. In the Projects Navigator, select one or more objects or modules, then click the Validate icon.

   • Examine the messages in the Validation Results window. Correct any errors and try validating again.

   • To redisplay the most recent validation results at a later time, select Validation Messages from the View menu.

   For additional information, see Validating Data Objects in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.

3. Configure the data objects.

   • To configure a data object, select the data object in the Projects Navigator and click the Configure icon. Or right-click the data object in the Projects Navigator and select Configure.

   • Configuring data objects specifies the physical properties of the object. You must not generate and deploy data objects without specifying the physical property values.

   • When you create data objects, OWB assigns default configuration property values based on the type of object. In most cases, these default values are appropriate. You can edit and modify the configuration property values of objects according to your requirement. For example, you configure a table to specify the name of the tablespace in which it is created.

4. When satisfied with the design of the target objects, generate the code.

   • In the Projects Navigator, select one or more objects or modules, then click the Generate icon. Examine the messages in the Generation Results window. To redisplay the most recent generation results at a later time, select Generated Scripts from the View menu.

   • Alternatively, in the Data Object Editor, you can generate code for a single object by clicking the Generate icon.

   • You can save the generated script as a file and optionally deploy it outside OWB.

   Generation produces a DDL or PL/SQL script to be used in subsequent steps to create the data objects in the target schema. For more information about generation, see Generating Data Objects in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.