Posting Yak Master
Posted - 10/24/2013 : 22:15:38
I got some Excel Data source with some Duplicate Data and Data Mismatch Values.
Like Customer Name and Their Address.
Name: Albert, Albart, Albert A, A Albert
Adress: 1st St, First St, First street, 1st street etc..
Need to Correct the Data and Remove the Duplication using SSIS. Currently I hv used Fuzzy Logic and cant able to Remove the Duplicate since there is no Reference Data, In this Ex Reference will be the same Excel data.
Help me some Logic to overcome this Data cleansing.