Matching Policy Usage

Question

HI All,

I have case where i have to merge data from different source and do cleansing and dump to specific destination .

so , in cleansing ,i want to do dups removal and spell check,also maintainging the accuracy with reference to third party (Azure).

For the ETL i m using the SSIS and cleansing pupose DQS,will DQS provide me the dups removal logic in same DQS component?

How to use the Matching policy of DQS in SSIS  ?

Answer 1

Currently we do not have matching activity via DQS in SSIS, but we do have the option of using fuzzy transformations in SSIS.

Saw a related question here: http://social.msdn.microsoft.com/Forums/en-US/sqldataqualityservices/thread/5db241c7-6f3e-4927-8c96-beb8e79025fb

---

Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )