Databases Reference
In-Depth Information
Metadata for the source table, a SAS data set called TigersHitting2002, is
available in a current metadata repository.
Output for the report will be sent to the
Output
tab in the Process Designer
window. The appropriate option must be set so that the
Output
tab appears in the
Process Designer window. For details, see “Process Designer Window” on page 20.
The main metadata repository is under change-management control. You do not
have to check out the metadata for the TigersHitting2002 table. (The metadata for
this table will not be updated.)
You have selected a default SAS application server for SAS Data Integration
Studio, as described in “Selecting a Default SAS Application Server” on page 96.
This server can access the TigersHitting2002 table that are used in the job.
It is assumed that you have started SAS Data Integration Studio and have opened
the appropriate metadata profile. For this example, the appropriate metadata
profile would specify the repository that will enable you to access the
PrintHittingStatistics transformation and the metadata for the source table, which
is TigersHitting2002.
Create and Populate the New Job
Follow these steps to create a complete process flow diagram, from sources, through
transformations, to targets:
1
From the SAS Data Integration Studio menu bar, select
Tools
Process
Designer
. The New Job wizard displays.
2
Enter
PrintHittingStats Job
in the
Name
field. Then enter a description for the job
in the
Description
field.
3
Click
Finish
. An empty job will open in the Process Designer window. The job has
now been created and is ready to be populated with the PrintHittingStatistics
transformation template and the source table, TigersHitting2002.
4
On the SAS Data Integration Studio desktop, click the
Process
tab to display the
Process Library.
5
In the Process Library, open the
UserDefined
folder and the
Reports
subfolder.
6
Click, hold, and drag the
PrintHittingStatistics
transformation into the
empty Process Designer window. Release the mouse button to display the template
in the Process Designer window for the new job, as shown in the following display.
Display 10.26
PrintHittingStatistics Template, Unpopulated
7
On the desktop, click the
Inventory
tab to display the Inventory tree.
8
In the Inventory tree, click and drag the
TigersHitting2002
table into the drop
zone (dashed-line box) in the Process Designer window, then release the mouse
Search WWH ::
Custom Search