The following instructions are from the help file for the Data Validation Transaformation. I need to see the error table results. What is not clear is #4. Does it create a table automatically or do I have to create a table for the errors records to be stored? I tried createing an error table and enteringg that in the options tab. Did not store any errors. Anyone familiar with this?
Configure Data Validation Settings 1. You can use the properties windows for the Data Validation transformation to perform the necessary configuration to validate your data. For example, the locations of the error and exception tables are specified in the sample job. Then, status handling conditions and actions are specified. Finally, the processing of duplicate and invalid values is configured for the job. Perform the following steps to complete this configuration:
2. Open the properties window for Data Validation transformation on the Diagram tab in the Job Editor window.
3. Click the Options tab. Then, click Data Validation to access the Data Validation section of the tab.
4. Enter a name for the error table file in the form LIBREF.FILENAME in the Enter an error table name field. In the sample table, the entry is sourcelib.PROD_ERROR_TABLE. The libref (sourcelib in this case) is assigned on the SAS Application Server when SAS is started on that host. The libref points to the library that is used to store the source table.
5. Click the Status Handling tab. Then, click New to add a new data exception row to the table.
Select Email Exception Report from the Action column for the table to access the Action Options window. The exception report stores messages that describe the actions that take place when you run the job.
6. Enter the e-mail address of the error report destination in the Email Address field. Click OK to save the address.
7. Click the Duplicate Values tab. Then, click New column to display the Duplicate Values window.
8. Move the appropriate column from the Available Columns field to the Selected Columns. The sample job uses the PRODUCT_NBR column.
9. Select appropriate values in the Tables to check and Action if duplicates fields. The sample job retains the default values of Source and Move all rows to error table. These values ensure that source rows with duplicate values are moved to the error table that is specified on the Options tab. The Duplicate Values window for the sample job is shown in the following displa
... View more