Stack Overflow
Stack Overflow

Questions tagged [data-quality-services]

Data Quality Services is a feature first deployed with SQL Server code-named "Denali" for automating data cleansing tasks

From Microsoft's website on DQS:

SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product. DQS enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data. DQS enables you to perform data cleansing by using cloud-based reference data services provided by reference data providers. DQS also provides you with profiling that is integrated into its data-quality tasks, enabling you to analyze the integrity of your data.

39 questions
0
votes
1 answer

DQS Composite Domain -- Raw Data Name Field Has Both People And Company Names

I'm trying to build a knowledge base in SQL Server 2012 DQS. In the raw data that I am trying to run through DQS, I've got a field that is a full name field that unfortunately can hold both human and company names. I was wondering if anyone had…
DrRocket
  • 85
  • 1
  • 5
0
votes
1 answer

Microsoft Data Quality Services Refresh of client view table error

I am trying to run SQL Server Data Quality Services on SQL Server 2014 with 32GB of RAM, plenty of disk space, and the latest updates (Microsoft SQL Server 2014 (SP2-CU2) (KB3188778) - 12.0.5522.0 (X64) Developer Edition (64-bit) on Windows NT 6.3 …
Alex K.
  • 1
  • 2
0
votes
1 answer

DQS failed to execute in the package SSIS 2012

I am new to used the SSIS! I'm trying to use the DQS within the package to apply the business role on a specific column in the source table i.e. Contact title. This column takes different job titles related to Sales people, matching the values on…
Dodi
  • 111
  • 4
  • 14
0
votes
0 answers

check nulls using dqs

I am new to SQL Server's Data Quality Services (DQS) feature. I have a source table with few INT and string type column. I need to implement a data quality rule in DQS using knowledge base domain to Identify the NULLS in the INT/String columns and…
INTOSQL
  • 1
0
votes
2 answers

Dedup and Combine Customer Data

I'm trying to combine records based on the ClusterID to have an enriched data of customer records. How will I be able to group the following using MS SQL? Coalesce won't work as records need to be on the same row to make it work, and if I have more…
mtryingtocode
  • 939
  • 3
  • 13
  • 26
0
votes
2 answers

DQS How to cleanse duplicates in master table and correct IDs in all referenced tables

We have lots of duplicates in a master table. See the below example, Customer ABC Corp exists 3 times in the master table and all 3 CustIDs are referenced in Orders table. **Customers…
MSBI-Geek
  • 628
  • 10
  • 25
0
votes
1 answer

Action 'Create data quality schema' finished with errors, aborting installation

During DQS installation, I get the following error message [2015/02/17 01:41:37 PM] Extracting script: DQS_Data.dqs [2015/02/17 01:41:37 PM] Extracting script: DefaultKbs.xml [2015/02/17 01:41:37 PM] Total scripts extracted: 25 [2015/02/17 01:41:37…
Mthokozisi Moyo
  • 55
  • 1
  • 6
0
votes
1 answer

Applying Domain Rules from SSIS

I have Created 15 Domain rules in Data Quality Service on Name Domain. Now I want to apply all rules for data cleansing purpose from SQL Server Integration Services(SSIS). I want to apply this 15 rules one after one(Step by Step). How can i achieve…
Jenish Jani
  • 5
  • 2
0
votes
1 answer

Can you use your own Reference Data Service in DQS?

The requirement is to use a list of contacts in a spreadsheet (excel/CSV) and "merge" this data with a microsoft SQL table. I've looked at Data Quality Services and i can't find a way to use my own Reference Data Service. Is there any other way to…
user2433237
  • 5
  • 4
1 2
3