Table of Contents

Search

  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Troubleshooting Corrupted Data

Troubleshooting Corrupted Data

If you use SQL*Loader to load data that is represented in an international character set, and the loaded data is corrupted, you can fix this issue by setting a property in the
cmxcleanse.properties
file.
  1. Navigate to the following directory:
    <MDM installation directory>/hub/cleanse/resources
  2. In an editor, open the file
    cmxcleanse.properties
    .
  3. At the end of the file, type the following property and specify the Unicode identifier for the international character set that matches the data you want to load.
    cmx.server.stage.sqlldr.charset=AL32UTF8
  4. Save the file.
  5. Run the stage process.
    The stage process generates a control file for SQL*Loader with the specified character set.
  6. Use the control file when you reload the data.

0 COMMENTS

We’d like to hear from you!