MDM Workflow Configuration & Hierarchy Management 3 — Questions and Answers
Question 1: In MDM Hub workflow configuration, what is the role of a 'Workflow Engine' such as ActiveVOS or Informatica Process Engine?
- It stores master data records in the ORS
- It executes and manages the lifecycle of workflow process instances (Correct answer)
- It performs data quality cleansing on incoming records
- It generates hierarchy rollup reports
Correct answer: It executes and manages the lifecycle of workflow process instances
The Workflow Engine is the BPEL/BPMN runtime that instantiates, tracks, and completes workflow process instances coordinated with MDM Hub.
Question 2: A hierarchy profile in Informatica MDM defines which of the following?
- The ETL mapping used to load hierarchy data
- The set of entity types and relationship types that form a named hierarchy view (Correct answer)
- The merge rules applied when consolidating hierarchy nodes
- The audit log configuration for hierarchy changes
Correct answer: The set of entity types and relationship types that form a named hierarchy view
A hierarchy profile groups entity types and relationship types together to define a specific, named hierarchical view of the data.
Question 3: Which MDM Hub workflow state indicates that a record has been reviewed but not yet approved by the final authority?
- ACTIVE
- PENDING (Correct answer)
- REJECTED
- REVIEWED
Correct answer: PENDING
PENDING state signals that the record has completed initial review and is awaiting a subsequent approval or decision action.
Question 4: When configuring task notifications in Informatica MDM workflow, which mechanism is typically used to send email alerts to data stewards?
- Direct JDBC calls to a mail server
- SMTP configuration within the workflow engine's notification service (Correct answer)
- An external ETL job triggered by a DB trigger
- Cloudara event bus integration only
Correct answer: SMTP configuration within the workflow engine's notification service
The workflow engine's built-in notification service uses SMTP configuration to send email alerts when tasks are assigned or escalated.
Question 5: In a hierarchy containing 'Company > Division > Department,' what MDM term describes the 'Division' node relative to 'Department'?
- Sibling
- Leaf node
- Parent node (Correct answer)
- Root node
Correct answer: Parent node
A parent node is the immediate ancestor of a given node in the hierarchy; Division is the direct parent of Department in this structure.
Question 6: Which configuration in MDM Hub controls the maximum number of levels allowed in a recursive hierarchy?
- Hierarchy Depth Limit in Hub Console
- Relationship Type's Max Depth property (Correct answer)
- ORS database parameter HM_MAX_DEPTH
- System property mdm.hierarchy.maxlevels
Correct answer: Relationship Type's Max Depth property
The Relationship Type configuration includes a Max Depth property that limits how many levels deep a recursive relationship can extend.
Question 7: In MDM workflow, what happens to a task when the configured SLA (service level agreement) deadline is exceeded?
- The record is automatically rejected
- The task is escalated to a higher-level role or manager (Correct answer)
- The workflow instance is terminated
- The SLA expiry is logged but no action is taken
Correct answer: The task is escalated to a higher-level role or manager
When an SLA deadline passes, the workflow engine triggers an escalation action, reassigning the task to a supervisory role to ensure timely resolution.
MDM Workflow Configuration & Hierarchy Management 3
In MDM Hub workflow configuration, what is the role of a 'Workflow Engine' such as ActiveVOS or Informatica Process Engine?