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 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 and load working
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
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 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
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 & Role
- 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
- Using JMS - Inbound & Outbound
- Logging
- Auditing
INFORMATICA DATA DIRECTOR(IDD)
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