Populating a Minischema for Text File Sources

If you created a minischema for your text file data source, choose from the list of available physical tables (files) in the data source to populate the minischema. You can also apply filters and add related objects to the files chosen for the minischema.

  To populate the minischema:

  1. In Populate 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 to move the tables 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 reused a minischema and selected the Clear existing schema check box, you must perform this step (see step 3 in Reusing an Existing Minischema for Relational Sources).

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

    To add all tables to the minischema, click the “Add all tables to the schema” button.

  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 only apply to tables listed in the Available Tables list.

    Note:

    The Add Related Objects button does not apply to files in a text file data source.

  4. Optional: To populate the minischema with objects 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 to select objects for this minischema.

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

  5. Click Next or Finish.

    Clicking Next takes you to the Create Metadata Elements page of the wizard, described in Creating Metadata Elements from Text File Sources.