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

Figure 5-8 ) . This will point to a DQS installation residing on a SQL Server instance.
Once the connection manager has been created, you select the knowledge base you
want to use. Selecting the knowledge base you want to use will bring up its list of do-
mains.
Figure 5-8 . The DQS Connection Manager and Cleansing Transformation Editor
As mentioned earlier in the chapter, there are two types of domains in this list; reg-
ular domains (e.g., City , State , Zip ), and composite domains, which are made up
of two or more regular domains. When using the DQS Cleansing transform, you can