Question

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 ?


Sponsored



Replies

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.

Thanks,
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)