MDM Workflow Configuration & Hierarchy Management 2 — Questions and Answers
Question 1: In Informatica MDM, which workflow trigger type initiates a process automatically when a record reaches a specific state in the state machine?
- Manual trigger
- Event-based trigger (Correct answer)
- Scheduled trigger
- API trigger
Correct answer: Event-based trigger
Event-based triggers fire automatically when a record transitions to a defined state, enabling straight-through processing without human intervention.
Question 2: When configuring a hierarchy in Informatica MDM Hub, what does the 'Relationship Type' setting control?
- The display order of child nodes in the UI
- The cardinality and direction of relationships between hierarchy nodes (Correct answer)
- The data type of the relationship key column
- The maximum depth of the hierarchy tree
Correct answer: The cardinality and direction of relationships between hierarchy nodes
Relationship Type defines cardinality (one-to-one, one-to-many) and directionality between parent and child nodes in a hierarchy.
Question 3: A workflow task is configured with 'Reviewer' and 'Approver' roles. In which order are these roles typically invoked in a standard multi-step approval workflow?
- Approver first, then Reviewer
- Both roles are notified simultaneously
- Reviewer first, then Approver (Correct answer)
- Order is determined by record priority only
Correct answer: Reviewer first, then Approver
In a standard multi-step workflow, Reviewers evaluate changes first and, upon acceptance, the task advances to Approvers for final sign-off.
Question 4: Which MDM Hub configuration object stores the task assignment rules that determine which user or role receives a workflow task?
- Task Type
- Assignment Rule (Correct answer)
- Role Configuration
- Workflow Trigger
Correct answer: Assignment Rule
Assignment Rules contain the logic (based on data attributes, user roles, or load balancing) that routes tasks to the correct user or group.
Question 5: In Informatica MDM hierarchy management, what is the purpose of the 'Effective Date' attribute on a relationship record?
- It defines when the hierarchy was created in the system
- It specifies the date range during which a parent-child relationship is valid (Correct answer)
- It controls when hierarchy changes are published to downstream systems
- It sets the expiration date for the child record
Correct answer: It specifies the date range during which a parent-child relationship is valid
Effective Date attributes allow time-variant hierarchy modeling so that parent-child relationships can be tracked as they change over time.
Question 6: When a workflow in MDM Hub is set to 'Auto-Accept,' what happens when all configured business rules pass validation?
- The record is placed in a pending queue for manual review
- The record is automatically promoted to the Active state without human intervention (Correct answer)
- The record is flagged for data steward notification only
- The workflow pauses and waits for a scheduled batch job
Correct answer: The record is automatically promoted to the Active state without human intervention
Auto-Accept bypasses the manual approval step and promotes the record directly to Active state when all validation rules are satisfied.
Question 7: Which table in the Operational Reference Store (ORS) stores the active hierarchy relationships between entity records?
- C_REPOS_HM_HRY
- HM_RELATIONSHIP (Correct answer)
- C_REPOS_EXT_ENTITY
- HM_HRY_PROFILE
Correct answer: HM_RELATIONSHIP
HM_RELATIONSHIP is the base table that records active parent-child relationships within a hierarchy in the ORS.
MDM Workflow Configuration & Hierarchy Management 2
In Informatica MDM, which workflow trigger type initiates a process automatically when a record reaches a specific state in the state machine?