Tips & Tricks: Informatica MDM Now Supports Record Locking

Attention MDM developers, did you know that Informatica Master Data Management MultiDomain Edition now supports record locking in addition to table locking? Now you can have a batch process and allow users to access data without locking the entire table.

As of release 9.x, MDM now supports record locking. Earlier versions of MDM MultiDomain allowed table locks, but newer versions (since 9.x) allow for record locking.

You can accomplish record locking by enabling “BATCH API Interoperability.”

BATCH API Interoperability specifies whether your Operational Reference Store (ORS) will allow row-level locking for concurrently-executing, asynchronous SIF and batch operations. If selected (e.g., checked), then row-level locking is allowed for asynchronous SIF and batch operations.  If not selected, which is the default, row-level locking is unavailable.

You enable record locking by setting the Batch API Interoperability property of the ORS as shown in Figure 1 below.


How to configure Batch API Interoperability

If you are using the Service Integration Framework API (SIF) or Informatica Data Director (IDD) you should set batch interoperability to ON.

For more information visit the Informatica Communities “how to” article on this topic.

Have comments or other questions regarding MDM?  Please post your comments below, send your comments and questions to Informatica University or join our community discussion at the Informatica University LinkedIn Group.


This entry was posted in Informatica University, Master Data Management and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>