MDM Architecture and Datamodel 2

Question 1

In Informatica MDM Hub, what is the purpose of the 'Schema Manager' tool?

Accepted Answer

To create and manage landing tables, staging tables, and base objects

Answer

To define and manage the physical schema of the ORS database

Answer

To configure Cleanse Match Servers

Answer

To manage user roles and access permissions

Question 2

Which MDM Hub component is responsible for comparing records to identify potential duplicates?

Accepted Answer

Match Rule Set

Answer

Cleanse Functions

Answer

Match Column

Answer

Consolidation Manager

Question 3

What does the 'Rowid Object' column represent in an MDM Hub base object table?

Accepted Answer

A unique system-generated identifier for each master record

Answer

A foreign key referencing the parent base object

Answer

The source system's original record key

Answer

A hash value used for change detection

Question 4

In the MDM Hub trust framework, what happens when two source records have the same trust score for a given field?

Accepted Answer

The record with the higher source system priority wins

Answer

The most recently loaded record wins

Answer

MDM Hub flags the record for manual review

Answer

The field value is left NULL

Question 5

Which table type in MDM Hub temporarily holds raw data before it is cleansed and matched?

Accepted Answer

Landing table

Answer

Base Object table

Answer

Cross-reference table

Answer

Relationship table

Question 6

What is the role of the 'Consolidation Indicator' (CONSOLIDATION_IND) column in MDM Hub base objects?

Accepted Answer

Indicates the current consolidation state of a record in the merge/unmerge lifecycle

Answer

Tracks which source contributed the golden record value

Answer

Stores the confidence score of the match process

Answer

Flags records that have been manually edited by a steward

Question 7

In Informatica MDM Hub's hub architecture, what is an 'Operational Reference Store' (ORS)?

Accepted Answer

A self-contained database schema storing all hub metadata and master data for a domain

Answer

A read-only analytical data warehouse fed by MDM Hub

Answer

A staging area external to MDM Hub used by ETL tools

Answer

A cache layer that speeds up match processing