Informatica MDM Online Training

Informatica MDM Online Training

Introduction of Master Data Management

  • What is MDM?
  • Why choose Informatica MDM
  • Installation overview
  • Explain DBMS Concept

Introduction to Informatica MDM Hub

  • Master Data
  • Master Data Management
  • A Reliable Foundation Of Master Reference Data
  • Components of MDM Hub
  • Application Server Tier
  • Database Server Tier
  • Batch Data Process Flow
  • Trust Framework
  • Consolidation Flag

Define the Data model

  • Data Mode Elements
  • Data Model
  • Relationships
  • Relationship Types
  • Lookups
  • Global Business Identifier (GB I D) Flag

Configuring stage and load process

Configure the Stage process

  • Basic Mappings
  • Complex Mappings
  • Cleansing and Transforming Data
  • Execution Component
  • Testing Mappings
  • Reusable Cleanse Components
  • External Data Cleansing
  • Delta Detection & Audit Trail
  • Rejects
  • Cleanse Match Servers
  • High-Level Stage Process Flow
  • Detailed Stage Process Flow

Configure the Load process

  • Trust
  • Validation Rule
  • Trust & Validation Rules: Things to note
  • Cell Level Update
  • Allow NULL Update
  • Allow NULL Foreign Key
  • How the Load work

Configuring merge process and data access

Configure the Match & Merge process

  • Match & Merge Overview
  • Key Activities for Configuring Rules
  • Match/Search Strategy for Base Objec
  • Population
  • Match Path, Columns and Match Key
  • Match Rules and Rule Sets
  • Primary Key Match Rules
  • Match Rules using Primary Key Match
  • Match Keys Distribution
  • Merge Settings
  • Match/ Merge Properties: Merge Style Base Object
  • External Match
  • Match Server Architecture

Configure data access views

  • Queries & Packages Overview
  • Query
  • Package

Batch processes and data management tools

Batch Processes

  • Batch Viewer
  • Batch Group
  • Executing Stored Procedures
  • Scheduling Considerations
  • Job Status & Job Statistics

Data Management Tools

  • Data Stewardship
  • Recap: Consolidation Flags
  • Merge Manager
  • Data Manager
  • Unmerge and Tree Unmerge

User exits and log files

User Exit Procedures

  • User Objects
  • User Object Registry Tool
  • User Exit & User Exit Procedure
  • Demo User exit procedure (using TOAD)
  • User Exits in the STAGE Process
  • User Exits in the LOAD Process
  • User Exits in the MATCH Process
  • User Exits in the MERGE Process
  • User Exits in the UNMERGE Process
  • Other logs Exit Procedures

Log files

  • Enterprise Manager
  • Hub Server Tab
  • Cleanse Servers Tab
  • Environment Report Tab
  • ORS Databases Tab
  • Database Log File
  • Application Server Log
  • Cleanse/ Match Server Logs
  • Console Log

Hierarchy management and security access manager

Hierarchy Management

  • Entities & Entity Type
  • H M Relation ships
  • H M Hierarchies
  • Hierarchy Management
  • H M Profiles
  • H M Packages

Security Access Manager(SAM)

  • Users, Resources, Privileges & Roles
  • Resources
  • Resource Groups
  • Privileges
  • Roles

Informatica data director

IDD Configuration

  • Business Data Director – User Interface
  • Create, Manage, Consume And Monitor
  • Data Model Elements
  • Configuration File
  • Subject Area
  • Subject Area Groups
  • B D D Data Display
  • Relationships
  • Application Validation
  • Importing an Application
  • Match Paths
  • Lookup
  • Cleansing
  • Resources and Privileges