Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

About Row-level Locking

About Row-level Locking

Informatica MDM Hub
uses row-level locking to manage data integrity when batch and
SIF
operations are executing concurrently on records in a base object. Row-level locking:
  • enables concurrent updates of base object data (the same base object but different records) from both batch and
    SIF
    processes
  • eliminates conflicts between online and batch processes
  • provides a high degree concurrent access to data, and
  • avoids duplication of the hardware necessary for a mirrored environment.
Row-level locking should be enabled if batch / API or API/API processes will be run asynchronously in your
Informatica MDM Hub
implementation. Row-level locking applies to asynchronous
SIF
and batch processing. Synchronous batch processing is restricted due to existing application-level locking.

0 COMMENTS

We’d like to hear from you!