Table of Contents


  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

Converting Data Types in the Input Table

Converting Data Types in the Input Table

In the
, a column with a DATE data type in the base object appears as a VARCHAR data type column in the associated EMI table. This issue occurs because the
converts dates to characters for data comparisons. You can avoid this issue if you convert DATE data types in the base object before you populate the EMI table.
  1. Identify the records in the base object that you want to convert. Make a note of the DATE values in both the column and the associated rowid_object.
  2. With a querying tool, select records of the DATE data type from the STRP table that corresponds with the base object record.
    The query returns records with data that resembles a date and time stamp in the SSA_DATA field.
  3. Use the date format mask
    to convert the DATE value in the base object into a VARCHAR value.
    Conversion Command
    Oracle and IBM DB2
    (to_char(date_column, 'YYYY/MM/DD HH24:MI:SS'))
    Microsoft SQL Server
    (convert(VARCHAR(10), date_column, 111) + ' ' + convert(VARCHAR(8), date_column, 108) ))
  4. Load data into the EMI table for external matching.
  5. Run an External Match job.
    The External Match job returns matches on DATE data types.


We’d like to hear from you!