Overview

Introduction

The Manage Master Data Management Solutions module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  • Create MDS Model and its Objects
  • Import Data using Staging Process
  • Export MDS Data by Creating Subscription Views

Exercise 1 - Create MDS Model and its Objects

In this exercise, you will learn the following in Microsoft SQL Server 2012:

Create an MDS model with entities, attributes, and attributes group

Exercise 2 - Import Data using Staging Process

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Populate Master Data Services Database by Importing data into staging tables and by processing the staged data as a batch

Exercise 3 - Export MDS Data by Creating Subscription Views

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Create subscription views to export or publish master data from the MDS database to other subscribing systems

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.