DQS Cleansing Transformation

The DQS Cleansing transformation uses Data Quality Services (DQS) to correct data from a connected data source, by applying approved rules that were created for the connected data source or a similar data source. For more information about data correction rules, see DQS Knowledge Bases and Domains. For more information DQS, see Data Quality Services Concepts.

To determine whether the data has to be corrected, the DQS Cleansing transformation processes data from an input column when the following conditions are true:

• The column is selected for data correction.

• The column data type is supported for data correction.

• The column is mapped a domain that has a compatible data type.

The transformation also includes an error output that you configure to handle row-level errors. To configure the error output, use the DQS Cleansing Transformation Editor.

You can include the Fuzzy Grouping Transformation in the data flow to identify rows of data that are likely to be duplicates.

Data Quality Projects and Values

When you process data with the DQS Cleansing transformation, a cleansing project is created on the Data Quality Server. You use the Data Quality Client to manage the project. In addition, you can use the Data Quality Client to import the project values into a DQS knowledge base domain. You can import the values only to a domain (or linked domain) that the DQS Cleansing transformation was configured to use.

Related Tasks

• Open Integration Services Projects in Data Quality Client

• Import Cleansing Project Values into a Domain

• Apply Data Quality Rules to Data Source

Related Content

• Manage (Open, Unlock, Rename, and Delete) a Data Quality Project

• Article, Cleansing complex data using composite domains, on social.technet.microsoft.com.

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN: Visit the Integration Services page on MSDN For automatic notification of these updates, subscribe to the RSS feeds available on the page.