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.

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.

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

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.

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.

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.