Manage Master Data Management Solutions

Practice Labs Module
Time
50 minutes
Difficulty
Intermediate

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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

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