Hands on Sessions

60 % Practical and 40 % theory approach

25 sessions

Daily 1-1.30 hours session

============================

COURSE CONTENT:

 

Informatica MDM Training Course Content

INFORMATICA MDM VERSION 10.1 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