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

Figure 5-9 . Mapping DQS knowledge base domains to columns in your data flow
Note If your data contains multiple columns with values from the same domain,
consider using the Linked Domain feature when creating your knowledge base. For
more information, see the “Create a Linked Domain” page in topics Online: ht-
tp://msdn.microsoft.com/en-us/library/hh479582.aspx .
Each column you map causes at least three additional columns to be added to your
data flow— Source , Output , and Status . More columns may be added, depending
on the advanced options you select (more on that to follow). The list of columns cre-
ated by the DQS Cleansing transform can be found in Table 5-2 . Each additional
column will be prefixed with the name of the original column by default and can be re-