Practice Test Geeks(MDM) Informatica Master Data Management Certification Practice Test
← All MDM Flashcard Decks

Data Modeling & Master Data Architecture Flashcards

7 cards from real MDM practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Modeling & Master Data Architecture flashcards as text

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

    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.

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

    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.

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

    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.

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

    Answer: Party model

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

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

    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.

  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?

    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.

  7. What does 'data stewardship' mean in the context of Informatica MDM Data Director?

    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.