Use the Warehouse Target notebook to import definitions of tables to include in your warehouse target.
The Available tables list contains the tables that are retrieved from the database catalog based on the filter criteria that you specify. When you move a table or individual column to the Selected tables list, you select it as a warehouse target. When you click OK, the newly selected table and column definitions are retrieved and defined in the warehouse. These new definitions will appear in this list when you reopen the Warehouse Target notebook or if you select the tables folder below the warehouse target node in the Data Warehouse Center tree.
To import target tables into a warehouse target:
On the Tables page, expand the Tables folder. The Filter window opens.
In the Filter window, specify the types of objects you want to import from the database.
Optional: Select Only tables that can be replicated to retrieve only those tables that have been enabled for replication.
Optional: Select Include system tables to retrieve system tables from the database.
Optional: In the Object schema field, type a search string, including wildcards, to define the characteristics of the schema names that contain the objects to be returned from the database. For example, XYZ* would return tables with schemas that start with these characters.
Optional: In the Object name field, type a search string, including wildcards, to define the characteristics of the table names to be returned from the database. For example, XYZ* would return tables that start with these characters.
Click OK. The objects that meet the filter criteria that you entered are displayed in the Available tables list.
Select the tables or individual columns that you want to include in your warehouse target from the Available tables list, and click >. The tables or columns that you selected are moved to the Selected tables list.
If you want to include all of the items in the Available tables list, click >>.
Go to the Security page if you're creating a warehouse target, or click OK to save your changes and close the Warehouse Target notebook.
Related information
Adding information about a warehouse target
Specifying database information for a warehouse target
Authorizing warehouse groups to access a warehouse target
Specifying an agent site to access a warehouse target