Table of Contents

Search

  1. Preface
  2. Introduction
  3. Getting Started with Repository Manager
  4. Validating Metadata
  5. Promoting Changes Between Repositories
  6. Importing Design Objects
  7. Exporting Repositories
  8. Common Warehouse Model Support
  9. Appendix A: Design Objects Reference
  10. Appendix B: Change List Reference
  11. Appendix C: MetCommand Reference

Logical Model and Physical Schema Should Match

Logical Model and Physical Schema Should Match

In an
ORS
, its metadata (logical model) should match its physical schema (tables and columns) exactly. For every metadata definition, there should be a corresponding physical component, and for every physical component there should be a corresponding metadata definition.
Certain events, however, can cause discrepancies between the metadata and physical schema. For example, a database administrator might make changes directly to the database instead of using the Schema Manager in the
Hub Console
. Similarly, database corruption might result from a power outage or hardware failure. The
Repository Manager
can help determine whether a discrepancy is inconsequential to
Informatica MDM Hub
operations, or whether it can cause major disruptions.

0 COMMENTS

We’d like to hear from you!