MDM Data Modeling & Master Data Architecture 3

Question 1

Which Informatica MDM component is responsible for standardizing and cleansing data before it reaches the staging tables?

Accepted Answer

Informatica Data Quality (IDQ) / PowerCenter integration

Answer

Informatica Data Quality or PowerCenter mappings perform cleansing and standardization as a pre-stage step before data enters MDM Hub staging tables.

Question 2

In Informatica MDM, what does 'hierarchy management' allow organizations to do?

Accepted Answer

Model parent-child relationships such as organizational structures or product categories

Answer

Hierarchy management in Informatica MDM models and navigates parent-child or network relationships, such as corporate org charts or geographic roll-ups.

Question 3

What is the significance of the 'hub UID' (ROWID_OBJECT) in Informatica MDM's data model?

Accepted Answer

It is the system-generated unique identifier assigned to each master record in the base object

Answer

ROWID_OBJECT is the MDM Hub-generated primary key for each base object record, independent of source system identifiers.

Question 4

Which data modeling approach in MDM uses 'party' as a single entity to represent both individuals and organizations?

Accepted Answer

Party model

Answer

The party model unifies Person and Organization into a single 'Party' entity, reducing data model complexity and enabling shared relationship management.

Question 5

In Informatica MDM, what is the purpose of 'state management' on base object records?

Accepted Answer

To classify records as ACTIVE, PENDING, or DELETED to control their visibility in master data

Answer

State management controls the lifecycle status of MDM records, ensuring only ACTIVE records are returned in master data queries.

(MDM) Informatica Master Data Management Certification Practice Test

(MDM) Informatica Master Data Management Certification Practice Test

MDM Data Modeling & Master Data Architecture 3