Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kalaiselvan
Posting Yak Master
112 Posts |
 Posted - 2013-10-24 : 22:15:38
|
| Hi, I got some Excel Data source with some Duplicate Data and Data Mismatch Values. Like Customer Name and Their Address. Ex: Name: Albert, Albart, Albert A, A AlbertAdress: 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.Regards,Kalai |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-25 : 02:00:05
|
| you need to have reference data in any case as you need to have a master set to which you do comparison. All previously explained ways work based on that.unless you do that system doesnt know which value to map each value to.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Data Cleansing Using SSIS 2008