โ† 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. In Informatica MDM, what does a 'base object' represent in the hub store?

    Answer: The consolidated master record that stores the best-version-of-truth data

    A base object in Informatica MDM Hub stores the consolidated, trusted master record after match and merge processing.

  2. Which concept describes the process of linking related master data entities across different domains in Informatica MDM?

    Answer: Relationship management

    Relationship management in Informatica MDM defines and manages links between entities such as Person-to-Organization or Product-to-Category.

  3. What is the purpose of a 'landing table' in the Informatica MDM staging process?

    Answer: It holds raw source records before they undergo any MDM processing

    Landing tables are the initial destination for raw source data before it is cleansed, standardized, and staged for MDM processing.

  4. In an Informatica MDM hub schema, what distinguishes a 'many-to-many' relationship table from a standard base object?

    Answer: It manages associations between two base objects without creating a new master entity

    A many-to-many relationship table in MDM Hub links two base objects (e.g., Person and Organization) to represent associations without creating a standalone master entity.

  5. Which MDM architectural pattern is BEST suited when a single authoritative version of master data must be stored centrally and all consuming systems reference it?

    Answer: Centralized (Consolidation) style

    The Centralized or Consolidation style stores the master record in a single hub that all systems treat as the system of record.

  6. In Informatica MDM, what is the role of 'trust settings' during survivorship?

    Answer: They define which source system's attribute value is most reliable and should be preferred in the golden record

    Trust settings assign confidence scores to source systems per attribute, guiding survivorship rules to select the most reliable value for the golden record.

  7. What is a 'cross-reference (XREF) table' used for in Informatica MDM Hub?

    Answer: To map source system record identifiers to the corresponding hub UID

    XREF tables maintain the mapping between each source system's record key and the MDM Hub's unique identifier (RowID), enabling lineage tracking.