Maintaining Processes

Overview

This chapter assumes that

you are familiar with how to define a Job and how to add processes to a Job Process Flow as described in Maintaining Jobs.
you are familiar with the basic information about processes as described in Processes and are ready to define properties for processes specified in Jobs.

You define properties for the following processes:

Mapping	generates or retrieves code that maps columns from one or more input sources into one or more output tables. Common mapping types include one-to-one (one input source to an output table). joins (one or more input sources merged by one or more common columns). unions (two or more input sources appended to an output table).
User Exit	retrieves user-written code, which, for example, could extract or transform information for a data store.
Data Transfer	generates or retrieves user-written code that moves data from one host to another. A Data Transfer process is required when the output table and its input source reside on different hosts.
Record Selector	generates or retrieves user-written code that subsets data prior to loading it to an output table. In the current release, you can specify a Record Selector process only to subset the input source data from an ODD or a Data File (which is an input to an ODD).
Load	generates or retrieves user-written code that loads data into an output table. A Load process is included automatically in a Process Flow that is associated with the output table.

In general, to maintain processes:

Note: You can access reference information for SAS/Warehouse Administrator process attributes windows by clicking Help. [cautionend]