Informatica Master Data Management Hub Tool

Explore the key MDM hub components: MGM hub for user and schema configuration, Informatica Data Director, services integration framework, provisioning tool, and Entity 360 for a view of customer data.

This lecture guides you through accessing the Oracle database, JBoss application server, and MDM hub. It covers obtaining urls, usernames, and passwords, testing connections, and navigating the MDM hub interface.

Explore the MDM hub menu bar, including file, database, lock and help options, learn how to log in with different users, and change the target database.

Learn to use the Informatica MDM hub tool's work benches and configuration sections, including security, access manager, data, sewer and utilities, and process server to manage databases, users, and workflows.

Register a database in the MDM hub by selecting the database type, providing schema name, password, database name, host, port, and service, then test the connection to the master database.

Create and manage users in the MDM hub by entering first name, last name, username, password, and email; configure internal authentication and assign access via the MGM Hub Master Database.

Log into the Informatica MDM hub tool, assign components and models to users via the toolbox, verify permissions with admin access, and manage tool visibility for test users.

Explore repository manager in the MGM configuration section to validate configurations, export and import change lists, and promote updates between environments, using xml change files.

Explore the configuration tools of the Informatica MDM hub, reviewing enterprise manager, security provider, workflow manager, and repository manager details; capture server versions, database details, and upgrade history.

Explore data modeling as the core of MDM hub implementation, focusing on physical data models and how they translate logical concepts into an underlying database using keys, indexes, and lookups.

Configure the solar system in the MDM hub by adding source systems such as CRM and Sales, then verify their entries in the database for landing and staging.

Configure landing, staging, and base object tables in the MDM hub, establishing data flow from landing to staging to the subject table with cleansing, delta, and golden records.

Configure landing table from base model, using abbreviated physical name like party, and define columns such as first name, middle name, last name, full name, and gender with source metadata.

Configure a base object table for the subject from the database model, and add business columns such as first name, middle name, last name, full name, gender, and party role.

Configure staging tables in the Informatica MDM hub, comparing a single landing table with per-source staging to per-source landing tables with staging, and manage columns and reject tables.

Configure relationships between party table and party rule lookup by declaring a unique primary key and linking via foreign keys; implement staging lookups using biggest object to standardize data.

View and navigate the master data model in schema viewer by exploring tables, columns, and relationships, switching between hierarchy and orthogonal views, and using zoom and scroll to inspect details.

Explore cleanse functions in the MDM hub to clean and standardize source data using string and noise functions, regular expressions, and date conversion across landing and staging.

Configure a mapping from the landing to staging tables in the MGM hub using a composite function that trims and uppercases names, then test the mapping with concatenation.

Configure delta detection and raw retention on staging tables using mapping columns or last updated, and learn how landing-to-staging mappings generate online learning table and roundtable.

Configure match rules and tokenization in Informatica MDM Hub to unify records on base and child tables, using fuzzy and exact matching for initial data and setting tokenization ratio.

Configure trust in the subject by setting source-based maximum and minimum trust, decay periods, and graph type, then apply rules to first name, middle name, last name, and full name.

Create and manage read and put queries in the MGM hub by forming query groups, building display queries across party and address tables, and applying filters.

Learn to create and manage packages in the Informatica MDM Hub: build display and put packages from party and lookup queries, review their database views, and update or insert records.

Configure Informatica master data management hub resources by marking them private or secure, manage access with security sources and privileges, and group resources into training, developer, or tester groups.

Create read-only and read-write roles in the Informatica Master Data Management Hub Tool, assign access to global resources and specific components, generate access reports, and manage role deletion.

Create user groups and assign read-only or read-write roles to developers and testers, connect to the master database, and map users to groups for secure mdm hub access.

Explore data flow in the MDM medium layer, moving data from landing to stage to subject tables, including tokenization, matching, and consolidation for publication to the convention layer.

Explore the different jobs generated in the MDM hub, including validate foreign key relationships, synchronization, and various match, merge, and tokenisation tasks, driven by table configurations and mappings.

Create batch groups in Informatica MDM hub to organize lookup and base object jobs, with levels that run parallel tasks and enforce party before address and phone.