You can use DataFlux
Data Management Studio to analyze the quality of the data sources
that are used in SAS Data Integration Studio jobs. For example, in
DataFlux Data Management Studio, you could create a profile that analyzes
the data in a table called
MANUFACTURERS.
The profile could reveal problems with the data, such as a column
that contains misspellings of company names. The profile in the next
figure shows a number of misspellings for the
Computer
Furniture company.
Profile Shows Data Errors in the Name Column of the MANUFACTURERS
Table
You can use the results
of data quality analysis to create SAS Data Integration Studio jobs
that will correct problems with the data. For more information about
the data quality features in DataFlux Data Management Studio, see
the
DataFlux Data Management Studio User’s Guide.