Databases Reference
In-Depth Information
Assume that the following preparations have been made.
The source table contains information on checking account transactions, including
status codes and the transaction amount, date, time.
Display 10.16
Contents of the Source Table CHECKING_TRANS
The lookup table CHECKING_TRANS_LOOKUP contains several columns of valid
values that can be used to test incoming source values.
The error table CHECKING_TRANS_ERROR and the target table
CHECKING_TRANS_VALID have the same column definitions (column metadata)
as the source table.
Metadata for all four tables is available in a current metadata repository.
The main metadata repository is under change-management control. You do not
have to check out the metadata for any of the tables used in the current example.
(The metadata for these tables 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 all tables that are used in the job.
It is assumed that you have started SAS Data Integration Studio and have opened
the appropriate metadata profile.
Create and Populate the New Job
Follow these steps to create and populate the new job:
1
From the SAS Data Integration Studio menu bar, select
Tools
Process
Designer
to display the New Job wizard.
2
Type the job name
Validate Checking Transactions
, press the TAB key, and
the enter the description
Cleanses checking account transaction data
prior to loading
.
3
Click
Finish
. An empty job opens in the Process Designer window. The job has
now been created and is ready to be populated.
4
From the SAS Data Integration Studio desktop, click the
Process Library
tab to
display the Process Library.
5
In the Process Library, open the
Data Transforms
folder.
6
Click, hold, and drag the
Data Validation
transformation into the empty Process
Designer window. Release the mouse button to display the transformation in the
Search WWH ::
Custom Search