Business Intelligence Tutorial

Selecting metadata to publish

To select the metadata that you want to publish:

  1. From the Data Warehouse Center window, right-click the Warehouse folder.
  2. Click Publish metadata.

    The Publish Metadata window opens.

  3. Right-click the white space in the window.
  4. Click Publish Data Warehouse Center metadata.

    The Publish Data Warehouse Center Metadata notebook opens.
    The Publish Data Warehouse Center Metadata window

  5. In the Available objects list, click TBC Tutorial located in the Subject Areas folder.
  6. Click >.

    The TBC Tutorial subject area moves to the Selected objects list.

  7. Click the Synchronization Settings tab.
    The Synchronization Settings page of the Publish Data Warehouse Center Metadata notebook
  8. In the Catalog name field, type TBC_MD.

    The TBC_MD database contains sample metadata, which includes a sample information catalog. You will add metadata about the Market process to the existing metadata.

  9. In the Administrator user ID field, type the user ID under which you installed the sample.
  10. In the Administrator password field, type the password that corresponds to the user ID.
  11. In the Verify password field, type the password again.
  12. From the Map Source Tables to Target Warehouse list, select the At the table level radio button to map source tables and target tables at the table level. The information catalog will indicate that there is a mapping between the two tables with a Transformation object.

    The other option you can select is At the column level to map source tables and target tables at the column level. The information catalog will indicate that there is a mapping between each column in the source table and its corresponding column in the target table. However, if there are many columns, the mappings in the information catalog can be quite complex.

    Accept the rest of the default values on this page. For more information about the fields on this page, see "Publishing Data Warehouse Center metadata" in the online help.

  13. Click OK.

    A status indicator is displayed until the publication of the objects is complete. When the publication is complete, the Publish Information window opens and displays the contents of a log file that lists which metadata objects were published successfully.

  14. Click Close on the Publish Information window.

    The window closes, and the log file is deleted. The Publish Metadata window opens listing your information catalog name in the List of publications.


[ Top of Page | Previous Page | Next Page | Table of Contents ]