Databases Reference
In-Depth Information
10
Click and drag the table
CHECKING_TRANS_VALID
into the target drop zone. The
table appears as the target in the new job, along with a Loader transformation, as
shown in the following display.
Display 10.18
Sources and Targets in the Data Validation Job
The job now contains a complete process flow diagram. The next task is to configure
the Data Validation transformation.
Configure the Data Validation Transformation
The example job has now been populated with a source, a target, and some
transformations. Follow these steps to configure the Data Validation transformation:
1
In the Process Designer window, double-click the
Data Validation
transformation to display the transformation's properties window. To use a lookup
table to validate values, click the
Invalid Values
tab.
2
On the
Invalid Values
tab, click
New
to display the Invalid Values window.
Click
Column Name
, display the columns of the CHECKING_TRANS table, and
select the column CHKING_TRANS_METHOD_CD.
Search WWH ::
Custom Search