MDM Services Integration Framework (SIF) 4 — Questions and Answers
Question 1: Which SIF API is used to manually promote a staging record directly to the base object, bypassing the standard batch load process?
- PutBvt (Correct answer)
- AcceptTask
- MergeRecords
- ExecuteCustomQuery
Correct answer: PutBvt
PutBvt writes data directly to the base object (golden record layer), bypassing the staging and batch load pipeline.
Question 2: In Informatica MDM SIF, what does 'EJB transport' mode provide compared to HTTP transport?
- Lower latency for in-JVM or same-cluster SIF calls by avoiding network serialization overhead (Correct answer)
- Support for asynchronous message delivery via JMS
- Built-in load balancing across multiple Hub Server nodes
- Automatic retry logic for failed SIF requests
Correct answer: Lower latency for in-JVM or same-cluster SIF calls by avoiding network serialization overhead
EJB transport provides faster in-JVM communication by using direct Enterprise JavaBean calls rather than going over the network stack.
Question 3: What happens in SIF when a 'PutRecord' call attempts to insert a record that already exists with the same primary key?
- It performs an upsert, updating the existing record with the new field values (Correct answer)
- It throws a duplicate key exception and rolls back the transaction
- It creates a second record with an auto-generated surrogate key
- It ignores the call and returns the existing record unchanged
Correct answer: It performs an upsert, updating the existing record with the new field values
PutRecord performs an upsert operation, inserting a new record or updating the existing one if the primary key already exists.
Question 4: Which SIF API is used to programmatically accept or reject a task in the MDM Hub Data Steward workflow?
- UpdateTask (Correct answer)
- ProcessBatch
- CompleteTask
- AssignTask
Correct answer: UpdateTask
UpdateTask allows programmatic resolution of workflow tasks by setting their status to accepted, rejected, or other workflow states.
Question 5: In SIF, what is the significance of the 'consolidation_ind' field on a cross-reference (XREF) record?
- It indicates whether the cross-reference record's data has been promoted to the golden record (Correct answer)
- It marks the record as the primary system of record for the golden record
- It flags duplicate cross-references for cleansing
- It controls whether the source record is visible in search results
Correct answer: It indicates whether the cross-reference record's data has been promoted to the golden record
The consolidation_ind flag on an XREF record shows whether that source contribution has been consolidated into the best version of truth.
Question 6: Which SIF method would you call to retrieve the hierarchy relationships (parent-child links) for a specific record in MDM Hub?
- GetHierarchyRelationships (Correct answer)
- GetXrefRecords
- SearchHierarchy
- GetBvt
Correct answer: GetHierarchyRelationships
GetHierarchyRelationships returns the parent-child and other defined hierarchy relationships for a target record.
Question 7: What is a key security consideration when configuring SIF API access for external applications in Informatica MDM Hub?
- Each SIF caller must supply valid MDM Hub credentials that map to an assigned Hub security role (Correct answer)
- SIF calls are always anonymous and rely on network-level ACLs for security
- SIF uses OAuth 2.0 tokens exclusively for all authentication
- SIF only supports certificate-based mutual TLS authentication
Correct answer: Each SIF caller must supply valid MDM Hub credentials that map to an assigned Hub security role
SIF enforces role-based access control by requiring caller credentials that map to Hub security roles governing which objects and operations are permitted.
MDM Services Integration Framework (SIF) 4
Which SIF API is used to manually promote a staging record directly to the base object, bypassing the standard batch load process?