Table of Contents

Search

  1. Preface
  2. Introduction to Informatica MDM - Supplier 360
  3. Supplier 360 Installation Overview
  4. Before You Install
  5. Installing the Supplier 360 Components
  6. After You Install
  7. Business Processes for Supplier Management
  8. Customizing Supplier 360
  9. Troubleshooting
  10. Upgrading MDM - Supplier 360

Guidelines for Extending the Data Model

Guidelines for Extending the Data Model

You can modify the definitions of tables or add new tables to the database.
Consider the following guidelines when you extend the data model:
  • Check if you can use an existing child base object.
  • Do not add a root base object to store the person or organization information.
  • Do not define tables with names greater than 24 characters.
  • Do not delete existing base objects.
  • Do not delete existing columns.
  • Do not modify the physical names of existing base objects. However, you can modify the display names.
  • Do not modify the data type of an existing column.
  • Do not decrease the length of an existing column.
  • Prefix the names of the new base object tables to distinguish the tables from the existing tables. The prefix indicates the type of table. Use the following naming convention when you create a base object:
    Prefix
    Table
    C_XO_
    Root or child record base object.
    C_XR_
    Relationship base object.
    C_XT_
    Lookup base object.
  • If you add a column to an existing table, prefix the name of a column with
    X_
    .
For more information about adding tables and columns, see the
Multidomain MDM Configuration Guide
.

0 COMMENTS

We’d like to hear from you!