Zahid's blog on Data Engineering and BI

A showcase of my experience in technologies like SQL, SSIS, SSAS, ETL, Azure, Power BI, DAX etc..

Composite Domain Rules (CD Rules) in Data Correction

April 9, 2012

Hello all I am just learning DQS and would like to share a few things that I learned so far. One of them is the use of composite domains (CD). I will go straight into an example rather than wasting time on definitions. You can find lots of them in MSDN. Let’s say, you have … More Composite Domain Rules (CD Rules) in Data Correction

Set Synonyms in DQS

April 9, 2012

This is my first post on the newly added Data Quality Service of MS SQL Server. It’s about setting up synonyms in Domain Values. The steps are : 1. select “domain management” activity for your knowledge base (KB) 2. select a domain from your domain list 3. select the “domain values” tab 4. select all the values … More Set Synonyms in DQS