Maintaining Information Marts

Example: Creating an Information Mart File

This example creates an Information Mart File that accesses a document.

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, Subject, Information Mart, and document already exist. [cautionend]

Define Information Mart File Properties

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

[untitled graphic]

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

General Tab

specifies the file name Toy Sales Doc, a description, an owner, and an administrator.

[untitled graphic]