Maintaining Information Marts

Example: Creating an Information Mart

This example creates an Information Mart to group related Information Mart Items and Information Mart Files.

Note: The following explanations describe the metadata and methods used to achieve the desired results. It is assumed that the appropriate Data Warehouse Environment, Data Warehouse, and Subject already exist. [cautionend]

Define Information Mart Properties

In the SAS/Warehouse Administrator Explorer, position the cursor on the Subject (for example, Toy Sales), click the right mouse button, select Add Item, and then Information Mart. In the Explorer window, a new Information Mart is added under the Subject as follows:

[untitled graphic]

To update the default metadata for the Information Mart, position the cursor on its icon, click the right mouse button, and select Properties. The Info Mart Properties window displays for you to enter the appropriate information.

General Tab

specifies the object name InfoMart for Toy Sales, a description, an owner, and an administrator.

[untitled graphic]

The next sections describe how to create an Information Mart Item and an Information Mart File.

Top of Page