Demo Video

Online Informatica MDM Training Video

About Course

What is Informatica MDM?

Master Data Management: It’s a method of identifying the most significant information in the organization, to one file (master file), which gives a general spot of reference.If done accurately, it simplifies the data sharing between the employees and the department. Additionally, it facilitates the computation in several system architectures and platforms and applications.

Overview

Overview of Informatica MDM

  • It authorizes organizations to develop operations with business-user accessing to combine regular business-critical data, even after scattering it across the organization.
  • Informatica family conveys true multiple domain masters data management, authorizing you with unlimited openings to start with any kind of business- significant data and adds as many numbers of domains as one likes to add.
  • Broadly accepted for its best performance, Informatica’s MDM products offer complete support for all MDM requirements on one platform, comprising of data integration, profiling, quality, and master data management.
  • The application approach to MDM begins with the user integration, and passes to business reasoning and lastly the data model. Its platform approach begins with the data model, and later goes to business logic and client interface.

Pre-requisites

Pre-requisites for Informatica MDM Online Training

  • Knowledge in SQL
  • Knowledge in RDBMS
  • MYSQL
  • DB2

FEATURES AND ADVANTAGES Informatica MDM

  • It is a flexible business model –driven MDM to fulfil the exceptional business requirements.
  • It’s complicated hierarchy management conceals the valued relations among the data.
  • Quickly installable and expandable multi-domain.
  • Operational proficiency is increased by the confiding in an extraordinarily reliable framework.

Course Content

Informatica MDM Training Course Content

INFORMATICA MDM VERSION 10.0 OVERVIEW AND ARCHITECTURE

  • 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

DATA MODELS AND LOOKUPS

  • Data Mode Elements
  • Data Model
  • Relationships
  • Relationship Types
  • Lookups
  • Global Business Identifier (GBID)

CONFIGURING 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

CONFIGURING 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

  • Match & Merge Overview
  • Key Activities for Configuring Rules
  • Match/Search Strategy for Base Object
  • 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

CONFIGURING DATA ACCESS

  • Queries & Packages Overview
  • Query
  • Package

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

  • User Objects
  • User Object Registry Tool
  • User exit in Java
  • 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

LOG FILES

  • Enterprise M anger
  • 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

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

SECURITY ACCESS MANAGER (SAM)

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

SERVICES INTEGRATION FRAMEWORK (SIF)

  • Introduction to Siperian SIF
  • SIF Framework
  • SIF Features & Benefits
  • SIF & Integration
  • Interacting with SIF
  • SIF Architecture & Protocols
  • SIF Request Object with Examples
  • Processing Responses
  • About Record
  • SIF APIs with Examples
  • ORS Specific APIs
  • Introduction to SIF Manager
  • Logging
  • Auditing

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
  • BDD Data Display
  • Relationships
  • Application Validation
  • Importing an Application
  • Match Paths
  • Lookup
  • Cleansing
  • Resources and Privileges

MESSAGE QUEUE

  • What are a Message Queues?
  • Create a Message Queue in Application server
  • Configure the ORS Specific Schema
  • Test the Queue
  • Configure the MRM to the Queue
  • Checking Message Queue count in App server.
  • Publish Message to the Queues