Table of Contents

Search

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

Updating the Reference Data

Updating the Reference Data

After you update
Customer 360
, update the reference data in the tables.
  1. Open a command prompt, and navigate to the following directory:
    <MDM installation directory>/app/tcr/data/reference-data
  2. Run one of the following scripts based on the database you use:
    • For Oracle.
      C360_lookup_script_oracle.sql
    • For Microsoft SQL Server.
      C360_lookup_script_MSSQL.sql
    • For IBM DB2.
      C360_lookup_script_DB2.sql
  3. To verify whether the lookup records are loaded successfully, perform the following tasks:
    1. In the Utilities workbench of the Hub Console, 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 is successful.
    4. If the load is unsuccessful, try running the load. Select
      BG_All_Lookup_Load
      and click
      Execute
      .

0 COMMENTS

We’d like to hear from you!