Introduction and defining data model

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

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

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