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
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.
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.
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.
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.
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.
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.
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.