Refering other source

Category: sql server dataquality


Ugaledeepak on Tue, 22 Jan 2013 05:55:27

HI All ,

Can i refer the other source (table from sql serve) to validate the data in DQS  KB ?


Paras Doshi on Tue, 22 Jan 2013 06:27:14

If you're referring to using SQL Server as "Reference" data than No, it's not possible as of today.

Kumar Vivek on Tue, 22 Jan 2013 09:05:22

Hi Deepak,

Paras is correct that you cannot refer directly to a SQL Server table (as reference data) to validate your data.

But you can import data from a SQL Server table to a DQS knowledge base using the knowledge discovery activity, publish the DQS knowledge base, and then run a cleansing activity against the knowledge base to cleanse your data.

(SQL Server Documentation | Twitter: @vivek_msft)