Should do the de-dup technique documented in the Microsoft site for SSIS should be followed in MDS?

Question

Should do the de-dup technique documented in the Microsoft site for SSIS should be followed today in MDS using SSIS?

https://learn.microsoft.com/en-us/archive/msdn-magazine/2005/september/using-the-sql-server-integration-services-for-data-cleansing

This article is based on a prerelease version of SQL Server 2005. All information contained herein is subject to change.

This article discusses:
SQL Server Integration Services
SQL Server 2005 Fuzzy Lookup and Grouping technology
Data-cleansing techniques

Answer 1

Hi @Anonymous ,

Although this article is very old, it still has great reference value.

The Fuzzy Lookup transformation performs data cleaning tasks such as standardizing data, correcting data, and providing missing values.

You may follow the article to do a local test.

I did some online research about SSIS Data Cleansing, several articles are still using the Fuzzy Lookups.

data-cleansing-process-tutorial

fuzzy-lookup-transformation

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October