targets (outputs) of a job. Can also be used to create an empty job into which you can drag and drop tables and transformation templates. “Process Designer Window” on page 105 Enables you to create process flow diagrams, to
generate and submit code for jobs, and to perform related tasks.
“Process Library Tree” on page 108 Enables you to drag and drop transformation templates into the process flow diagrams for jobs. “Job Properties Window” on page 111 Enables you to view or update the basic
metadata for a job (metadata other than its process flow diagram).
“Table Properties Window” on page 112 Enables you to view or update the metadata for a source table or a target table, such as metadata for its columns, indexes, keys and other attributes.
“Transformation Property Windows” on page 112 Enables you to view or update the metadata for a transformation in the process flow diagram for a job.
“Transformation Generator Wizard” on page 113 Enables you to create a user-written, SAS code transformation and make it available in the Process Library tree. This is one of the easiest ways to customize SAS ETL Studio.
New Job Wizard
Use the New Job wizard to select one or more tables as the targets (outputs) of a job. It can also be used to create an empty job into which you can drag and drop tables and transformation templates.
One way to display the New Job wizard is to select Tools I Process Designer
from the menu bar on the SAS ETL Studio desktop. The first window in the wizard is shown in the following display.
104 New Job Wizard 4 Chapter 9
Display 9.2 New Job Wizard
The first window enables you to enter a name and description for the new job. The second window of the wizard enables you to select one or more tables as the targets (outputs) of a job, as shown in the following display.
Display 9.3 New Job Wizard, Second Window
The wizard uses the selected table(s) to generate a transformation template—a process flow diagram that includes drop zones for metadata that the user must supply.
Introduction to SAS ETL Studio Jobs 4 Process Designer Window 105
For example, if the Staff Sorted table is selected as the target, the wizard would generate the transformation template that is shown in Display 9.4 on page 105.
Display 9.4 Transformation Template for Sort Staff Job
To update a process flow diagram, drag and drop tables from the Inventory tree or another tree in the tree view. Drag and drop transformation templates from the Process Library tree.
Alternatively, in the second window of the New Job wizard, you can select no targets and simply click Finish after entering a name for the job. The wizard will open an empty job in the Process Designer window. After you have an empty job, you can create a process flow diagram by dragging and dropping tables and transformations into the Process Designer window. This is the approach that is described in “Create and Populate the New Job” on page 115.
Process Designer Window
Use the Process Designer window to perform these tasks:
3 maintain the process flow diagram for the selected job
3 view or update the metadata for sources, targets and transformations within the selected job
3 view or update the code that is generated for the entire selected job or for a transformation within that job
3 view a log that indicates whether code was successfully generated for the selected job or for one of its transformations (and was successfully executed, if the code was submitted for execution)
3 view any output that the selected job or one of its transformations sends to the SAS output window.
106 Process Designer Window 4 Chapter 9
Display 9.5 Process Designer Window
In the previous display, the Process Designer window contains the process flow diagram for the Sort Staff job that is described in “Jobs with Generated Source Code” on page 100. Note that theProcess Editortab is shown by default. You might have to use the Options window to display the other tabs in the Process Designer window or to specify options for these tabs. For details, see “Options Window” on page 18.
The following steps describe one way to open an existing job in the Process Designer window:
1 From the SAS ETL Studio desktop, display the Inventory tree.
2 In the Inventory tree, expand the Jobs group.
3 Select the desired job, then select View I View Job
from the menu bar. The process flow diagram for the job displays in the Process Editortab of the Process Designer window.
If the diagram is too large to view in theProcess Editortab, select View I Overview
from the menu bar. A small image of the complete process flow diagram displays in the Overview window.
To change the size or the orientation of the process flow diagram, select Process I Zoom
or
Introduction to SAS ETL Studio Jobs 4 Process Designer Window 107
from the menu bar.
The tabs in the Process Designer window are described in the following sections. To display the online help for each tab, select the tab and press the F1 key.