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: Glossary

Importing Column Definitions From Another Table

Importing Column Definitions From Another Table

You can import some of the column definitions from another table.
  1. Navigate to the column editor for the table that you want to configure.
  2. Acquire a write lock.
  3. Click the
    Import Schema
    button.
    The Import Schema dialog box opens.
  4. Specify the connection properties for the schema that you want to import.
    If you need more information about the connection information to specify here, contact your database administrator.
    For IBM DB2 environments, the settings for the user name and password fields depend on whether proxy users are configured for the MDM Hub implementation.
    • If proxy users are not configured, then the user name is the same as the schema name.
    • If proxy users are configured, specify the custom user name and password.
    For more information about proxy user support, see the
    Multidomain MDM Installation Guide
    .
  5. Click
    Next
    .
    The database you enter does not need to be the same as the
    Operational Reference Store
    that you are currently working in, nor does it need to be an
    Operational Reference Store
    .
    The only restriction is that you cannot import from a relational database that is a different type from the one in which you are currently working. For example, if your database is an Oracle database, then you can import columns only from another Oracle database.
    The Schema Manager displays a list of the tables that are available for import.
  6. Select that table that you want to import.
  7. Click
    Next
    .
    The Schema Manager displays a list of columns for the selected table.
  8. Select the columns you want to import.
  9. Click
    Finish
    .
  10. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!