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

Operational Reference Store Properties

Operational Reference Store Properties

Properties of the
Operational Reference Store
databases include database vendor and version, as well as information from the C_REPOS_DB_RELEASE table.
The following list describes the
Operational Reference Store
properties that appear in the
Enterprise Manager
tool:
Database Product Name
Name of your database system.
Database Product Version
Database version used.
Environment ID
The environment ID.
TNS Name
TNS name of the
Operational Reference Store
database.
Connect URL
URL to connect to the
Operational Reference Store
database.
Database ID
The database ID.
Time difference between systems
Delta-detection value, in seconds, which determines if the incoming data is in the future.
Column length in bytes
For Oracle environments.
Used by SQL*Loader to determine if the database it is loading into is a UTF-8 database.
The default value is 1, which means that the database is UTF-8.
Load template
For
IBM DB2
environments. The path on the database server for log files that the db2 load command generates when you are in logging mode.
MTIP regeneration required
If set to
true
, it indicates that the MTIP views will be regenerated before the match/ merge process.
The default value is
false
, which means that views will not be regenerated.
The Regenerate MTIPs button of the
Enterprise Manager
tool lets you regenerate MTIP views.
You must not regenerate MTIP views when the ORS is in production mode. Switch off production mode setting before trying to regenerate MTIPs from the
Enterprise Manager
tool.
Global no logging
For Oracle and IBM DB2 environments. This is used when tables are created to enable logging for database recovery. The default value is
true
, which means no logging.
Model Repository Service URL
Connection parameters that the
MDM Hub
requires to connect to the Model Repository Service. You specify the connection parameters in the
Enterprise Manager
tool.

0 COMMENTS

We’d like to hear from you!