MDM Data Integration & Synchronization Techniques 2 — Questions and Answers
Question 1: In Informatica MDM, what is the primary purpose of the Stage process in the data integration pipeline?
- To publish master records to downstream systems
- To load raw source records into the landing and staging tables (Correct answer)
- To apply consolidation rules across golden records
- To generate workflow notifications for data stewards
Correct 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.
Question 2: Which Informatica MDM component is responsible for detecting and resolving conflicts when the same entity is updated in multiple source systems simultaneously?
- Schema Manager
- Trust Framework (Correct answer)
- Hierarchy Manager
- Relationship Manager
Correct 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.
Question 3: What does the term 'survivorship' refer to in Informatica MDM data integration?
- The process of archiving deleted records for audit purposes
- Rules that determine which source attribute values populate the golden record (Correct answer)
- The mechanism for routing rejected records to error queues
- A technique for compressing duplicate records in the Hub Store
Correct 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.
Question 4: In MDM Hub, what is the function of the 'delta detection' step during the Stage process?
- Identifying records that have changed since the last load to avoid reprocessing unchanged data (Correct answer)
- Calculating the statistical difference between two golden records
- Detecting mismatches between source schema and Hub schema
- Flagging records that exceed the maximum allowed field length
Correct 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.
Question 5: Which synchronization pattern does Informatica MDM use when it pushes updated golden records back to subscribing source systems?
- Publish-Subscribe (Correct answer)
- Request-Reply
- Polling-Pull
- Batch-Append
Correct 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.
Question 6: 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?
- Increase the match threshold for System A records
- Lower the trust score assigned to System A for the affected attributes (Correct answer)
- Disable delta detection for System B
- Set System A's staging table to read-only mode
Correct 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.
Question 7: What is the role of the 'message queue' in Informatica MDM's real-time data integration architecture?
- Storing archived golden records for historical reporting
- Buffering inbound source updates and outbound golden record publications for asynchronous processing (Correct answer)
- Holding rejected records pending manual data steward review
- Caching match scores to speed up repeated match operations
Correct 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.
MDM Data Integration & Synchronization Techniques 2
In Informatica MDM, what is the primary purpose of the Stage process in the data integration pipeline?