question

htp avatar image
htp asked

Cleansing service in SQL Server 2008 R2 Master Data Service

Does Master Data Service has some in built mechanism to deal with cleansing of data? Or, is there some cleansing service available that works with SQL Server 2008 R2 Master Data Services?
sql-server-2008-r2master-data-services
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
WilliamD avatar image
WilliamD answered
There will probably be some form of commercially available cleansing service, other than that I think you will be better off doing some sort of SSIS implementation. You would define rules for the data and run the import through them into MDS. However, I have heard that MDS is a dog in the current version and should be avoided - there are errors in it IIRC (heard that inofficially at the PASS Summit from an MVP - I forget who exactly).
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.