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
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)