1 May 2012

How to reuse a DQS Domain

Q: I have created a Domain in a Knowledge Base that I want to reuse it in other Knowledge Bases. Can I copy & paste a domain from one Knowledge Base into an other?

A: You can export and import a domain.
- Go to the domain you want to reuse.
- Right click the domain and select [Export] and then [Export Domain].
- Choose a location and filename and click [Save]
- Close the current Knowledge Base and open the new Knowledge base
- Click on the import domain button and select the exported file.

In this video example I 'copy' the Country Domain from the DQS sample Knowledge Base:

28 April 2012

How to remove a Knowledge Base

Q: How do I remove a redundant DQS Knowledge Base?

A: Go to [Open Knowledge Base], Right-click your redundant Knowledge Base and select "Delete".



Data Quality Services Client : 11.0.2100.60
Data Quality Services Server : 11.0.2100.60

22 April 2012

DQS performance hotfix

There is a new Hotfix available for DQS to boost the performance for large datasets (> 1.5 million records): http://support.microsoft.com/kb/2679368/en-us

FIX: Slow performance when you use DQS to perform a data cleansing against a large data source in SQL Server 2012. More info.

Don't forget to run DQSInstaller.exe-Upgrade after installation