โ† All MDM Flashcard Decks

Data Integration & Synchronization Techniques 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 Integration & Synchronization Techniques flashcards as text
  1. What is the role of 'tokenization' in Informatica MDM's match process?

    Answer: Generating standardized search keys from record attributes to enable efficient matching

    Tokenization generates match tokens (standardized search keys) from record attributes, allowing the match engine to efficiently identify potential duplicate records.

  2. An organization wants to synchronize MDM golden records with a Salesforce CRM in near-real-time. Which Informatica capability is best suited for this integration?

    Answer: Informatica Cloud Data Integration (IICS) with MDM SaaS connector

    Informatica Cloud Data Integration (IICS) provides pre-built connectors and real-time synchronization capabilities between MDM and cloud applications like Salesforce.

  3. In Informatica MDM, what does 'unmerge' allow data stewards to do?

    Answer: Separate previously merged source records back into independent records

    Unmerge allows data stewards to reverse an incorrect merge by separating the source records that were consolidated into a golden record, creating distinct records again.

  4. Which MDM Hub configuration controls how frequently the batch consolidation job runs automatically in a scheduled integration scenario?

    Answer: The job scheduler configuration within the MDM Hub or an external scheduler like Control-M

    Batch consolidation jobs are scheduled via the MDM Hub's built-in scheduler or an external enterprise scheduler, controlling the frequency of match-merge cycles.

  5. When multiple source systems provide the same entity (e.g., a customer), Informatica MDM creates one golden record. What mechanism links the golden record back to all contributing source records?

    Answer: The XREF (cross-reference) table

    The XREF table stores the cross-references between each golden record's ROWID_OBJECT and the source system records that contributed to it, preserving full data lineage.

  6. In Informatica MDM Hub, what is the purpose of 'cleanse functions' applied during the Stage process?

    Answer: Standardizing and normalizing source data values before matching and consolidation

    Cleanse functions standardize source data (e.g., name parsing, address normalization) during staging so that the match engine can accurately identify duplicates.

  7. A company uses Informatica MDM for customer data and wants changes to golden records to trigger updates in a downstream data warehouse within minutes. Which approach achieves this?

    Answer: Configure MDM publication events to a message queue consumed by the warehouse ETL in near-real-time

    Publishing golden record change events to a message queue allows the warehouse ETL to consume updates within minutes, achieving near-real-time synchronization.