Previous Page | Next Page

Maintaining Information Marts

Preparing to Create Information Marts

Before you create an Information Mart and its associated Information Mart Items and Information Mart Files, you must do some preparation, which is summarized as follows:

Hierarchy of objects

In SAS/Warehouse Administrator, make sure that you have created the appropriate Data Warehouse Environment, Data Warehouse, and Subject, Data Group, or ODD Group.

Input source(s)

Determine which input source(s) to use for each Information Mart Item and Information Mart File. For example, if the input source for an Information Mart File is an ODD, the ODD must be fully operational.

Processes

For an Information Mart Item, determine the user-written source code, which produces the output, and determine the SAS catalog entry in which to store it.

Determine whether you need to define processes such as a User Exit process, Data Transfer process, or Record selector process. Information Marts do not have Mapping processes.

Output target

Determine the appropriate location for each Information Mart Item and Information Mart File.

Determine on what platform you want to store the Information Mart File and Information Mart Item. That is, you could store the data store locally or on a remote host.

Previous Page | Next Page | Top of Page