Microsoft SQL Server 2008 R2 Master Data Services
Microsoft SQL Server Master Data Services (MDS) enables organizations to manage and maintain business data used to make critical business decisions. MDS is a Master Data Management (MDM) application, which standardizes and streamlines the critical data entities of an organization, essentially centralizing your master data.
A focused, practical tutorial, this book will show you how to manage and maintain your organization's master data and improve data quality with Microsoft SQL Server 2008 R2 Master Data Services. Using credible techniques and an end-to-end approach, this book will take you through the steps required to implement Master Data Management, enabling business users to standardize and streamline their business data.
This book will enable you to manage and maintain your organization's master data with Microsoft SQL Server 2008 R2 Master Data Services, covering each feature in a step-by-step manner. The book starts with an overview of Master Data Management. You will then move on to an overview of Microsoft SQL Server 2008 R2 Master Data Services (MDS). The book then dives deep into topics such as installing, configuring, and maintaining Master Data Services, creating and using Models, Version Management, Business Rules, and importing Data into Master Data Services amongst others.
|Course Length||10 hours 48 minutes|
|Date Of Publication||18 Jul 2011|
|The staging load process|
|Populating MDS step 1—populating the staging tables|
|Creating new members|
|Creating new collections|
|Adding members to collections|
|Updating member attributes|
|Deleting a member (or collection)|
|Populating MDS step 2—invoking the staging process|
|Populating MDS step 3—validating the model|
|Clearing the staging tables|
|Errors in the staging process|
|Automating the MDS load process with SSIS|