DQS is a knowledge-driven data cleansing solution that ensures high quality data, improves accuracy, data consistency and resolve problems cause by bad data entry in BI or data warehouse or OLTP systems.
It helps business user or a non-database professional to create, maintain and execute their organization’s data quality operations with minimal setup or preparation time and with excellent quality.
It improves the data quality by creating a Knowledge Base (KB) about the data and then clean the data based on the knowledge in the knowledge base.
It has been introduce in SQL Server 2012
Asked In: Many Interviews |