Maintaining Jobs

Example: Adding a Record Selector Process to a Process Flow

A Record Selector process is a metadata record used to generate or retrieve user-written code that subsets data prior to loading it to a specified output table. A Record Selector process can be specified only to subset the input source data specified in an ODD or in a Data File (which is an input to an ODD).

Note: The following explanation describes the metadata and methods used to achieve the desired results. It is assumed that the appropriate Data Warehouse Environment, Data Warehouse, Subject, data stores, Job, and Process Flow exist. [cautionend]

Adding a Record Selector Process

In the SAS/Warehouse Administrator Explorer, position the cursor on the Job to which you want to add a Record Selector process to its Process Flow, for example Customer. Click the right mouse button, and select Process. The software opens the Process Editor with the Process Flow displayed.

[untitled graphic]

To add a Record Selection, in the Process Flow, right-click the Process Flow arrow above the ODD input source, and select Add Record Selector

[untitled graphic]

To update the default metadata for the Record Selector process, position the cursor on the Record Selection icon, click the right mouse button, and select Properties. The Record Selection Process Attributes window displays.

[untitled graphic]

For an explanation about defining the Record Selector properties, see Example: Defining Record Selector Process Properties.

Top of Page