...management, Kalido said. Specifically, the integrated matching technology enables customers to: -- De-dupe and matchrecords from different sources to help build gold-copy master data, and then automatically create and maintain those mapping...
http://www.intelligententerprise.com/showArticle.jhtml?articleID=217300179
...data or its structure and format, and then load the transformed data into the data warehouse. Performing lookups to matchrecords from source systems to existing records in the data warehouse is a common operation in ETL processes, and in SQL Server...
http://www.arbelatech.com/documents/SQL/SQL%202008%20Business%20Intelligence.pdf