Configuration Guide

10.3

Back Next

Converting Data Types in the Input Table

In the

MDM Hub

, 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

MDM Hub

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.

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.

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.

Use the date format mask

YYYY/MM/DD HH24:MI:SS

to convert the DATE value in the base object into a VARCHAR value.

Database	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) ))