Skip to Content
0
Former Member
Jul 08, 2015 at 07:51 AM

Reimporting a permanent table is changing data types

368 Views

Hi,

I had a template table that was imported as a permanent from an Oracle 11g database.

I'm using DS 14.2.2.596.

Field types Int and Date were kept ("Schema Out") as in the "Schema In" during the first import:

ATL code:

RECORD INT NULL SET("ui_mapping_text" = 'Query.RECORD'),

DATE_OF_BIRTH DATE NULL SET("ui_mapping_text" = 'Query.DATE_OF_BIRTH'),

But if I reimport the same permanent table again, those field types are changed as follows:

Int ---> Decimal (28,0)

Date ---> Datetime

This is causing errors in the jobs execution.

ATL code:

RECORD DECIMAL(28, 0) NULL ,

DATE_OF_BIRTH DATETIME(0) NULL ,

All the attribute parameters in the "Tools/Options/Designer/Attribute Values" are set to "Preserve".

In older DI versions there was a utility "fixupUIMapText" to fix issues regarding the attribute "ui_mapping_text".

Can anyone have had this same Data Services issue?

Thanks,

Francisco