Maintaining Processes

Using the Process Library

SAS/Warehouse Administrator provides a Process Library, which is a collection of registered routines that you can use to extract data, transform it, and load it into a data store. For example, there are routines that standardize addresses, and there are routines that generate the code required to load a warehouse table into a DBMS, such as Oracle, using native loading software.

As you define processes in a Process Flow, you have the option of selecting a predefined routine from the Process Library, rather that supplying user-written code.

The Process Library is made up of a registered set of Process Catalogs. A Process Catalog is a SAS catalog that has a specific set of entries and performs a specific process. The MAIN entry in a Process Catalog is a reference to the routine that actually performs the process.

For more information about the Process Library, click Help on the Process Library window.

Note: Initially, the Process Library is empty. You can install routines as add-in tools from the SAS/Warehouse Administrator Solutions CD, which is provided with SAS/Warehouse Administrator software. [cautionend]

Top of Page