Populating a Minischema for Relational Sources

  To populate the minischema:

1. In Populate Minischema, to remove tables from the minischema, from the Tables in schema list, select the tables you DO NOT want to include in the minischema, then click the Remove selected tables from the schema button.

   The tables are moved to the Available Tables list

   To move all tables to the Available Tables list, click the Remove all tables from the schema button.

   Note:

   In the Select Minischema page of the wizard, if you chose to reuse a minischema and selected the Clear existing schema check box, this step is required (see step 3 in Reusing an Existing Minischema for Relational Sources).

2. To add tables to the minischema, from the Available Tables list, select the tables to include, and then click the Add selected tables to the schema button.

   The tables are moved to the Tables in Schema list.

3. Optional: To apply a filter to tables listed in Available Tables , enter the filter in the Filter text box, and click Apply.

   Note:

   Filters apply only to tables listed in the Available Tables list.

4. Optional: To add related objects to the minischema, select one or more tables in the Tables in Schema list, and click the Add Related Objects button.

   For example, if you added a table to the Tables in Schema list, selecting that table and clicking Add Related Objects adds to the list any tables that are joined to that table.

5. Optional: To populate the minischema with tables from another data source:

   1. In Connections, select the data source to which you want to connect.

   2. In Databases, select the database from which you want to select tables for this minischema.

   3. Repeat step 1 through step 4 for all data sources from which you want to add tables to this minischema.

6. Click Next or Finish.

   Clicking Next takes you to the Create Metadata Elements page of the wizard, as described in Creating Metadata Elements for Relational Sources.