SAS Data Integration Studio P36:This manual is a companion to the online Help for SAS Data Integration Studio. The Help describes all windows in SAS Data Integration Studio, and it summarizes the main tasks that you can perform with the software. The Help includes examples for all source designer wizards, all target designer wizards, and all transformation templates in the Process Library tree. | 170 Configure the Data Validation Transformation A Chapter 10 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 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. Example Process Flows A Configure the Data Validation Transformation 171 3 Click the browse button to the right of the Lookup Table field and select CHECKING_TRANS_LOOKUP. Then click ok to return to the Data Validation properties window. Display Invalid Values Window 4 To specify the name of the error table click the Options tab. In the Error Table row enter the SAS libref and filename rather than the metadata names of the error table such as . Click Apply to store your input. 5 To replace missing values click the Missing Values tab then click New. In the Missing Values window select the column CHKING_TRANS_CHANNEL_CD. In the Action if missing field select Change value to. In the New Value field type with quotation marks. Click OK to return to the properties window. Display Missing Values Window 6 To configure the detection of duplicate values click the Duplicate Values tab. Click New to display the Duplicate Values .
