Data Cleansing Applications with SQL Server Integration Services

Author: msdn.microsoft.com | Published: 10th Aug 2005 | Visited: 796 times | Add Comment
Filed in: SQL Server

Data quality is a critical issue in data integration. Donald Farmer introduces the data quality features of SQL Server Integration Services with demos that show how to use the Fuzzy Lookup component for inexact matching and how to use Data Mining within the data integration process.

Read Article

Sponsored Links

• Swing Extreme Testing - The Data Validation Test The Data Validation Test The Ok button of the SaveAsDialog should only be enabled if the name that has been entered is valid. A name can be invalid if it contains an illegal character, or if it has already been use ...

• SOA Approach to Integration Book Review Book Review: SOA Approach to Integration XML, Web services, ESB, and BPEL in real-world SOA projects Businesses will always need highly efficient applications which have ability to provide outstanding user experience while maintaining security. Most of the developers today thrive in a business set ...

• SOA Web Services - SOA and Web Services Approach for Integration SOA and Web Services Approach for Integration In Chapter 2, you were introduced to how Service-Oriented Architecture (SOA) can be used for application integration. We saw that the integration itself may be restricted within an Enterprise or may involve third parties (B2B or B2C). Service-Oriented A ...

• SOA Web Services - SOA Evolution SOA Evolution In the 1980s, applications were mostly vertical, built to meet the customer requirements in a vertical market segment. The software solutions were sufficient to meet the needs of a vertical industr ...

• SOA Web Services - IT Evolution IT Evolution Looking at current business needs, the IT environments in world need to be more flexible, and must quickly adapt to the constantly changing business requirement ...

• Reducing Code Size of Ajax Applications Building an Ajax based applications is mostly difficult due to the fact that codes are usually rendered longer. Because different web developments are used in building an Ajax based applications, developers have to combine these codes so that they can achieve the asynchronous function of Ajax. If th ...

• Bind Web Services in ESB-Web Services Gateway Bind Web Services in ESB-Web Services Gateway Since SOI is all about integrating multiple SOA-based systems, web services play a critical role in the integration space. This chapter is all about the importance of web services in integration. We will use the samples to illustrate how to bind web serv ...

• Business Intelligence Integration Business Intelligence Integration How to Integrate Business Intelligence within Your Organization Before you Integrate Business Intelligence into your Organization Business Intelligence has developed into strategic process over the years of its extraordinary growth, even so it still needs to be i ...

• Retrieving XML Data Retrieving XML DataTo retrieve XML data from an XMLType table, you can use a SELECT SQL statement, just as you would if you had to query a relational table. For example, to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section, you might issue ...

Next: Microsoft SQL Server: SQL Server 10-Year Anniversary