Business Intelligence And Data Warehousing Software Directory

Data Integration Solutions for Master Data Management

Details: The tutorial article illustrates how to address the data integration issues of Master Data Management (MDM) using Microsoft SQL Server 2005 Integration Services (SSIS). The tutorial provides an overview of a high-performance enterprise architecture of Microsoft SSIS and guides through the SSIS data integration capabilities which help meet the data requirements for MDM. The tutorial sections are based on sample business scenarios and it shows how to use SSIS in real data warehouse environments

The tutorial depicts the most widely used SSIS features, such as: data cleansing functions, fuzzy grouping, fuzzy lookups, conditional split, applying custom business rules, using Derived Column transformation, using Aggregate and Merge Join transformations, extracting attributes with Term Lookup and Term Extraction and more.