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

Installation and Configuration Guide

Installation and Configuration Guide

Inserting Reference Data

Inserting Reference Data

After you import the metadata, you can populate the tables with some reference data. By using reference data, you can complete the configuration steps faster, because you do not have to insert the rows into the tables manually.
  1. At a command prompt, navigate to the following directory:
    <MDM installation directory>/app/tsr
    /hub/schema/reference-data
  2. Use a database tool to run the following script:
    Supplier_lookup_script_oracle.sql
  3. Verify that the lookup records loaded successfully from the Hub Console.
    1. In the Hub Console, in the Utilities workbench, click
      Batch Group
      .
    2. Expand
      BG_All_Lookup_Load
      and select
      Control & Logs
      .
    3. In the Logs for each job table, review the Status column to verify that the load was successful. The Total records column shows the number of records added. The columns to the right of the Total records column displays zeros if all records load successfully.
    4. If the load was unsuccessful, try running the load. Select
      BG_All_Lookup_Load
      and click
      Execute
      .
  4. Use a database tool to run the following script:
    INSERT_C_REPOS_APP_CONFIG_ORACLE.sql
    The table C_REPOS_APP_CONFIG is populated with reference data.

0 COMMENTS

We’d like to hear from you!