Practice Test Geeks(MDM) Informatica Master Data Management Certification Practice Test
← 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. In Informatica MDM Hub, what distinguishes a 'base object' from a 'staging table'?

    Answer: A base object stores the consolidated master records while a staging table holds pre-processed source data

    Base objects in MDM Hub contain the consolidated golden records, while staging tables hold raw source data that has been loaded but not yet merged.

  2. Which Informatica MDM batch job must be executed to promote staged records through match, merge, and consolidation?

    Answer: Consolidate job

    The Consolidate (or Match and Merge) batch job processes staged records through match rules, identifies duplicates, and merges them into golden records.

  3. When configuring a source system integration in Informatica MDM, what does 'rowid_object' represent?

    Answer: The MDM Hub's internal unique identifier for each base object record

    ROWID_OBJECT is the MDM Hub's system-generated unique identifier for each record in a base object, used internally for cross-referencing and relationship management.

  4. What is the purpose of the cross-reference (XREF) table in Informatica MDM?

    Answer: Tracking which source system records contributed to each golden record

    The XREF table maintains the relationship between each golden record and the individual source system records that were merged to create it, enabling lineage and un-merge operations.

  5. An MDM architect needs to integrate a real-time POS system that sends individual transaction records every second. Which integration approach is most appropriate?

    Answer: SIF (Services Integration Framework) API calls for real-time record processing

    The Services Integration Framework (SIF) API enables real-time, record-by-record integration suitable for high-frequency transaction sources like POS systems.

  6. Which process in Informatica MDM ensures that updated golden records are automatically reflected in subscribing applications without requiring those applications to query the Hub?

    Answer: Publication

    The Publication process pushes updated golden records to downstream subscribers via message queues or services, implementing event-driven synchronization.

  7. In MDM Hub's data integration, what is the significance of the 'hub state indicator' (HUB_STATE_IND) column on a base object record?

    Answer: It indicates the consolidation state of the record, such as pending merge or active golden record

    HUB_STATE_IND tracks the processing state of a record within the MDM Hub, indicating whether it is active, pending consolidation, or in another workflow state.