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
In Informatica MDM, what is the primary purpose of the Stage process in the data integration pipeline?
Answer: To load raw source records into the landing and staging tables
The Stage process loads raw source data into the MDM Hub's landing and staging tables, preparing it for subsequent match and merge operations.
Which Informatica MDM component is responsible for detecting and resolving conflicts when the same entity is updated in multiple source systems simultaneously?
Answer: Trust Framework
The Trust Framework uses configurable trust scores and validation rules to resolve data conflicts when the same attribute is updated by multiple source systems.
What does the term 'survivorship' refer to in Informatica MDM data integration?
Answer: Rules that determine which source attribute values populate the golden record
Survivorship rules define how the golden record is constructed by selecting the best attribute values from competing source systems based on trust, recency, or custom logic.
In MDM Hub, what is the function of the 'delta detection' step during the Stage process?
Answer: Identifying records that have changed since the last load to avoid reprocessing unchanged data
Delta detection compares incoming source records against previously staged data to identify only the changed records, improving performance by avoiding redundant processing.
Which synchronization pattern does Informatica MDM use when it pushes updated golden records back to subscribing source systems?
Answer: Publish-Subscribe
Informatica MDM uses the publish-subscribe pattern, where the Hub publishes updated golden records as events and subscribing source systems receive those updates.
A data integration architect notices that source records from System A frequently override higher-quality data from System B. Which MDM configuration should be adjusted?
Answer: Lower the trust score assigned to System A for the affected attributes
Reducing the trust score for System A's attributes ensures that System B's higher-quality values survive the consolidation process and populate the golden record.
What is the role of the 'message queue' in Informatica MDM's real-time data integration architecture?
Answer: Buffering inbound source updates and outbound golden record publications for asynchronous processing
Message queues (such as JMS queues) buffer both inbound source record updates and outbound publication events, enabling asynchronous and decoupled real-time integration.