View Course Agenda

MDM: Multidomain Edition Configuration

Instructor Led | MDM | 4 Days

MDM: Multidomain Edition Configuration

Course Overview

This course is applicable to software version 10.2. Discover the skills necessary to configure a data model and business rules in Informatica MDM Multidomain Edition (MDM Hub) for a given data model and set of business rules. Through extensive hands-on labs and exercises, students to gain confidence in the use of MDM console. 

Enroll Now

Objectives

After successfully completing this course, students will be able to:
  • Define and create a data model within MDM 
  • Configure MDM processes including Stage, Load, and Match 
  • Leverage Merge Manager and Data Manager for Merge and Unmerge processes
  • Utilize Log files

Target Audience

  • Developer


Agenda

Module 1: Introduction 

  • Master Data Management definitions
  • Goals of Master Data Management (MDM)
  • Key capabilities of Informatica's Multidomain Edition (MDM Hub) solution
  • Informatica MDM Hub Application Server and Database Server tiers
  • Master data workflow within the Informatica MDM Hub
  • Capabilities of the Trust Framework

Module 2: Define the MDM Data Model  

Lesson 1: Define the Data Model
  • Landing tables purpose, content and best practices
  • Base object tables purpose and content
  • Staging tables purpose and content 
  • Creating Landing tables, base object tables, and staging tables
Lesson 2: Customer Data Models
  • Creating landing tables from Sales source system
  • Creating the Customer base object 
  • Creating staging tables for Customer data from the Sales and CRM source systems 
Lesson 3: Relationships
  • Identifying One-to-Many and Many-to-Many relationship types
  • Foreign-key relationships between base objects of the data model
  • Many-to-many relationships between the base objects of the data model

Module 3: Configuring the Stage Process

Lesson 1: Process Server & Creating Mappings
  • Purpose of the Process Server
  • Registering a Process Server
  • Basic and complex mappings
  • Building blocks used in transformational logic mapping
  • Purpose of a function
  • Associating function types to descriptions
  • Predefined function types
  • Constants
  • Conditional Execution Component
  • Basic Mapping
  • Cleanse List
  • Reusable Cleanse components with descriptions
  • Supported external data cleansing options
  • Testing a mapping
  • Graph and cleanse functions in a Mapping
Lesson 2: Configuring Delta Detection and Audit Trail
  • Delta Detection purpose
  • Conditions for using delta detection
  • Conditions under which Data Rejection occurs
  • Characteristics of Audit Trail
  • Delta detection options and raw data retention periods
  • Stage Process Flow sequence
  • No error jobs
  • Batch Viewer
  • Stage job

Module 4: Configuring the Load Process

Lesson 1: Setting Trust, Validation Rules, and the Load Process
  • Overview of Trust
  • Calculating the trust 
  • Conditions for leveraging Trust 
  • Characteristics of Validation Rules
  • Setting trust
  • Behaviors for switching on or off various functions
  • Adding a Validation Rule
  • Setting Cell and Null Updates
  • Load process for UPDATES, INSERTS, and REJECTS

Module 5: Configuring Match and Merge Processes

Lesson 1: Match and Merge Overview 
  • Resolving issues with Master Data Management 
  • Resolving duplication
  • Challenges associated with duplicate records
  • Purposes of Matching and Merging
  • Exact and Fuzzy matching
  • Match Tokens
  • Match Path
  • Match Columns
  • Characteristics of the Provider Columns for Match Columns
  • Multiple records match on multiple columns
  • Match Process Flow
  • Configure matching in the MDM Console

Lesson 2: Configuring Exact Matching
  • Match rules
  • Exact matching
  • Match rule properties for filtering (Matching NULLS and Segment Matching)
  • Match rules using match columns

Lesson 3: Configuring Fuzzy Matching
  • Fuzzy matching
  • Characteristics of Populations
  • Matching population types to their descriptions
  • Match Keys
  • Key Type matching keys property
  • Key Width match key property
  • Search level used in Fuzzy matching
  • Configuring a range search 
  • Fields for standard populations
  • Match Purpose fuzzy rules property
Lesson 4: Configuring the Merge Process
  • Consolidation state of a record
  • Sequence of the Merge Process
  • Distinguish when to use Automatic versus Manual Merge methods
  • Immutable Source System
  • Distinct system
  • Rules of a distinct source system
  • Unmerge Child When Parent Unmerges option
  • Selecting Merge Properties (Match/Merge Setup Details)
  • Automatic match and merge
  • Running automatic match and merge jobs

Module 6: Configuring Data Access Views 

Lesson 1: Creating Queries and Packages
  • Goals of queries and packages
  • Impact Analysis tool 
  • Packages types
  • Creating a PUT-enabled package

Module 7: Configure Batch Processes

Lesson 1: Configuring and Executing Batch Processes
  • Jobs most often assembled into Batch Groups
  • Assembling a Batch Group
  • Batch Groups, Batch Group Levels, Batch Jobs 
  • Creating and Executing a Batch Group

Module 8: Utilize Data Management Tools 

Lesson 1: Managing Records with Merge Manager and Data Manager
  • The purposes of Data Steward and Merge Manager
  • Editing and merging records manually
  • Using Data Manager
  • the results of an unmerge
  • Standard and tree unmerge 

Module 9: System Information and Logs 

Lesson 1: Enterprise Manager
  • MDM Hub Console Enterprise Manager tabs
Lesson 2: Log Files
  • Log files related to the MDM Hub Console 
  • Using Enterprise Manager's ORS Database tab

Module 10: User Objects 

Lesson 1: User Exits and Custom Objects
  • User objects registered with MDM
  • User Object Registry tool 
  • User Exits 
  • Exits used in the Stage, Load, Match, Merge, and Unmerge processes

Module 11: Additional MDM Product Features 

Lesson 1: Brief Overview of Additional Features
  • Exporting an ORS to a changelist using Metadata Manager

 
Enroll Now

Back to Course Overview


QUESTIONS?

Instructor Led | MDM | 4 Days | Version 10.2 | 

Print Friendly and PDF