Data Correction with Data Quality Services - SQL Server Integration Services Design Patterns - page 145

Figure 5-4 . Creating a new data cleansing project
After you've mapped your columns to domains, DQS will process your data and
provide you with the results of the cleansing operation. When you review the results,
you have the option to approve or reject certain corrections, add new values to the list
of known domain values, and specify correction rules. For example, as the data steward
for your organization, you know that “Jack Ryan” and “John Ryan” are the same per-
son. After approving the corrections, you can export the results to a SQL Server table,
Excel file, or CSV file. DQS does not give you the option to correct the value in-
place—you will need a separate process to update the original source data you ex-
amined.
At various times during the process you can save your data quality project. The
project status is saved to the DQS server, allowing you to resume at a later point. This
is especially useful when working with large sets of data that can take awhile to scan. It
also allows you to come back to the correction results in case you need to do some re-
search on what the correct values should be for a particular domain.
To manage your active data quality projects, click on the Open Data Quality Project
button on the home page of the client. From here, you can see all projects that are cur-
rently in progress. Right clicking on a project gives you management options, such as
renaming the project or deleting it if it is no longer needed.
Administration
The Administration section is available to users in the DQS Administrator's role. From
here, you can monitor all activity on the DQS server (such as Domain Management and
Cleansing projects), and set system wide configuration options. From these pages, you
can set logging levels for various operations, as well as set the minimum confidence
scores for suggestions and automatic corrections. If you are using online reference data
from the Windows Azure Marketplace, you will configure your account information
and service subscriptions from this page as well (as shown in Figure 5-5 ).