DQS Cleansing Transformation
Applies To: SQL Server 2016
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.
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.
Article, Cleansing complex data using composite domains, on social.technet.microsoft.com.