Google News
logo
SQL Server - Interview Questions
What do you understand by the data quality services in SQL Server?
The data quality services in SQL Server is a knowledge-driven data quality product. SQL Server Data Quality Services (DQS)  enable the user to build a knowledge base and thereafter use it to perform tasks such as correction, deduplication, enrichment, standardization of data.
 
Apart from this, DQS also provides profiling and enables you to perform data cleaning with the help of cloud-based data services.
 
DQS consists of two components :
 
* Data Quality Server : It is an SQL Server instance feature consisting of three SQL Server catalogs with data-quality functionality and storage

* Data Quality Client : It is an SQL Server feature which users can use to perform computer-assisted data quality analysis and manage their data quality interactively.
Advertisement