Facebook Twitter LinkedIn YouTube E-mail
Home Posts tagged "DQS"
formats

Getting Value from Your Data – SQL Server Data Quality Services

Share

These days organizations of all sizes rely on data (and increasing amounts and types of it) to make informed decisions, and more of their employees, across roles and departments, need data to execute on their jobs. But are they working with data at a quality level acceptable for the intended purpose? Often not. Incorrect and

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Getting Value from Your Data – SQL Server Data Quality Services  comments 
formats

Starting Your Journey with SQL Server 2012 Data Quality Services (DQS)

Share

Data Quality Services (DQS) Introduction Data Quality Services (DQS) is a native component in SQL Server 2012. The data-quality solution provided by DQS enables a data steward or IT professional to maintain the quality of their data and ensure that the data is suited for its business usage. DQS is a knowledge-driven solution that provides

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Starting Your Journey with SQL Server 2012 Data Quality Services (DQS)  comments 
formats

Using Data Quality Services to Cleanse Source Data in Integration Services

Share

So far we’ve seen various methods of cleansing source data using Data Quality Services. One of the main applications of DQS is in SQL Server Integration Services. This is where source data can be cleansed using the knowledge bases maintained in the DQS client by launching the DQS cleansing transform available in Integration Services. This blog gives

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Using Data Quality Services to Cleanse Source Data in Integration Services  comments 
formats

Generating High Quality Source Data Using Microsoft Data Quality Services Knowledge Base

Share

In the previous post on DQS, you can see how to setup the DQS server client application for starting a data quality activity. Now that the configuration is done, the next step is to create and maintain a knowledge base within the DQS client application for providing a reference dataset for the data cleansing activity.

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Generating High Quality Source Data Using Microsoft Data Quality Services Knowledge Base  comments 
formats

Configuring Microsoft Data Quality Services to Generate Quality Source Data

Share

This is the first in the series of posts on Microsoft data quality services. It will give you an overview on how to setup the data quality services application before using it for data quality related activities. A common pain point in any warehousing project is to ensure the quality of the source data. This

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Configuring Microsoft Data Quality Services to Generate Quality Source Data  comments