| ActiveMac | Anonymous | Create a User | Reviews | News | Forums | Advertise |
|
|
|
User Controls |
|
New User |
|
Login |
|
Edit/View My Profile |
|
|
|
|
|
|
|
ActiveMac |
|
Articles |
|
Forums |
|
Links |
|
News |
|
News Search |
|
Reviews |
|
|
|
|
|
|
|
News Centers |
|
Windows/Microsoft |
|
DVD |
|
ActiveHardware |
|
Xbox |
|
MaINTosh |
|
News Search |
|
|
|
|
|
|
|
ANet Chats |
|
The Lobby |
|
Special Events Room |
|
Developer's Lounge |
|
XBox Chat |
|
|
|
|
|
|
|
FAQ's |
|
Windows 98/98 SE |
|
Windows 2000 |
|
Windows Me |
|
Windows "Whistler" XP |
|
Windows CE |
|
Internet Explorer 6 |
|
Internet Explorer 5 |
|
Xbox |
|
DirectX |
|
DVD's |
|
|
|
|
|
|
|
TopTechTips |
|
Registry Tips |
|
Windows 95/98 |
|
Windows 2000 |
|
Internet Explorer 4 |
|
Internet Explorer 5 |
|
Windows NT Tips |
|
Program Tips |
|
Easter Eggs |
|
Hardware |
|
DVD |
|
|
|
|
|
|
|
Latest Reviews |
|
Applications |
|
Microsoft Windows XP Professional |
|
Norton SystemWorks 2002 |
|
|
|
Hardware |
|
Intel Personal Audio Player 3000 |
|
Microsoft Wireless IntelliMouse Explorer |
|
|
|
|
|
|
|
Site News/Info |
|
About This Site |
|
Affiliates |
|
ANet Forums |
|
Contact Us |
|
Default Home Page |
|
Link To Us |
|
Links |
|
Member Pages |
|
Site Search |
|
Awards |
|
|
|
|
|
|
|
Credits |
 |
Fuzzy Lookup and Fuzzy Grouping in Data Transformation Services for SQL Server 2005 | |
|
||
| Time: 03:13 EST/08:13 GMT | News Source: ActiveWin.com | Posted By: Robert Stein | ||
|
This paper describes the Fuzzy Lookup transformation and Fuzzy Grouping transformation in Data Transformation Services (DTS) for SQL Server 2005. Fuzzy Grouping transformations are useful for improving data quality at the destination database. Fuzzy Lookup matches input that is "dirty"—because of misspellings, truncations, missing or inserted tokens, null fields, unexpected abbreviations, and other irregularities—with clean records in a reference table. Fuzzy Grouping detects similarities between input rows and determines which rows are duplicates by using their string values. Fuzzy Grouping and Fuzzy Lookup are useful primitives that can simplify a variety of data cleaning and preparation tasks that are frequently encountered in data warehousing. By customizing them for your domain, you can leverage general search and clustering algorithms inside the DTS Designer while avoiding complex custom code. | ||
|
Write Comment
Return to News |
Displaying 1 through 25 of 142 Last | Next |
The time now is
5:39:58 PM
ET.
Any comment problems? E-mail us |
|
Write Comment
Return to News |
Displaying 1 through 25 of 142 Last | Next |
The time now is
5:39:58 PM
ET.
Any comment problems? E-mail us |
