INFORMATICA MDM COURSE CONTENT:

1.INTRODUCTION AND DEFINING DATA MODEL

a.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

b.Define the Data model

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

2.CONFIGURING STAGE AND LOAD PROCESS

a.Configure the Stage process

• Basic Mappings
• Complex Mappings
• Cleansing and  Transforming  D a t a
• 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

b.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

 3.CONFIGURING MERGE PROCESS AND DATA ACCESS

  a.Configure the Match & 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

   b.Configure data access views

• Queries & Packages Overview
• Query
• Package

4.BATCH PROCESSES AND DATA MANAGEMENT TOOLS

 a.Batch Processes

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

 b.Data Management Tools

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

5.USER EXITS AND LOG FILES

 a.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

 b.Log files

• Enterprise M a n a g e r
• Hub Server Tab
• Cleanse Servers Tab
• Environment  Report  Tab
• ORS Databases Tab
• Database Log File
• Application Server Log
• Cleanse/ Match Server Logs
• Console Log

6.HIERARCHY MANAGEMENT AND SECURITY ACCESS   MANAGER

a.Hierarchy Management

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

b.Security Access Manager (SAM)

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

7.SERVICES INTEGRATION FRAMEWORK

• 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
• Using JMS – Inbound & Outbound
• Logging
• Auditing

8.INFORMATICA DATA DIRECTOR

a.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