Databases Reference
In-Depth Information
Check the HTML Report
Using the path and file name that you specified in the Publish to Archive
transformation, open the HTML report in a browser. The report should resemble the
following display.
Display 10.15 HTML Report Generated by the Example Job
Compare the HTML report to the draft report shown in Display 10.1 on page 150. If
changes are needed, change the properties of the Total_Sales_By_Employee table or the
transformations in the flow. If the report is correct, you can check in the job.
Check In the Metadata
To check in all objects in the Project tree:
1 In the Project tree, select the repository icon.
2 From the SAS Data Integration Studio menu bar, select Project ￿ Check In
Repository . All of the objects in the project repository are checked into the
change-managed repository.
Example: Creating a Data Validation Job
Preparation
Suppose that you wanted to validate the data from a source table before writing it to
a target table. SAS Data Integration Studio has several features that can help you to
improve the quality of your data, as described in “Working With SAS Data Quality
Software” on page 104.
This example demonstrates how to use the Data Validation transformation in a job
that prepares checking transaction data for loading into a fact table. In the example
job, the Data Validation transformation writes erroneous rows into an error table.
Errors are detected based on a comparison of a source column to a column of valid
values in a lookup table. The transformation also replaces missing values in another
source column with a standard text string; any duplicate values that are found in a
third source column result in the termination of the job.
 
Search WWH ::




Custom Search