MDM Data Modeling & Master Data Architecture 3 — Questions and Answers
Question 1: Which Informatica MDM component is responsible for standardizing and cleansing data before it reaches the staging tables?
- Data Director
- Siperian Hub Console
- Informatica Data Quality (IDQ) / PowerCenter integration (Correct answer)
- Repository Manager
Correct answer: Informatica Data Quality (IDQ) / PowerCenter integration
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?
- Define which attributes are mandatory in a base object
- Model parent-child relationships such as organizational structures or product categories (Correct answer)
- Set data retention policies for archived records
- Configure match rules between different base objects
Correct answer: Model parent-child relationships such as organizational structures or product categories
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?
- It is a source-system identifier carried over during staging
- It is the system-generated unique identifier assigned to each master record in the base object (Correct answer)
- It tracks the version number of a record after each merge
- It stores the hash value used for match key generation
Correct answer: It is the system-generated unique identifier assigned to each master record in the base object
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?
- Subject area model
- Party model (Correct answer)
- Canonical data model
- Entity-relationship model
Correct answer: Party model
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?
- To track which source system last updated the record
- To classify records as ACTIVE, PENDING, or DELETED to control their visibility in master data (Correct answer)
- To manage geographic state/province attributes
- To log which workflow step a record is currently in
Correct answer: To classify records as ACTIVE, PENDING, or DELETED to control their visibility in master data
State management controls the lifecycle status of MDM records, ensuring only ACTIVE records are returned in master data queries.
Question 6: When designing a master data model for Product MDM, which attribute type would be stored in a 'child extension object' rather than the core base object?
- Product SKU
- Product name
- Product category-specific attributes that vary by product type (Correct answer)
- Product creation date
Correct answer: Product category-specific attributes that vary by product type
Category-specific attributes (e.g., technical specs for electronics vs. nutritional info for food) are stored in child extension objects to keep the core base object lean.
Question 7: What does 'data stewardship' mean in the context of Informatica MDM Data Director?
- Automated batch processing of incoming source records
- The human review and resolution of data quality issues, merge conflicts, and unmerge requests (Correct answer)
- The process of replicating master data to downstream systems
- Configuration of match rules within the Hub Console
Correct answer: The human review and resolution of data quality issues, merge conflicts, and unmerge requests
Data stewardship in Data Director involves human review and correction of suspect matches, merge conflicts, and data quality exceptions.
MDM Data Modeling & Master Data Architecture 3
Which Informatica MDM component is responsible for standardizing and cleansing data before it reaches the staging tables?