question

DataArtist avatar image
0 Votes"
DataArtist asked ZoeHui-MSFT edited

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

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

https://docs.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

sql-server-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
1 Vote"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @DataArtist,

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.