Netezza datatype

[Former Member]

Hello,

We are in the processing of migrating from Netezza DB to Oracle Exadata DB.

We are trying to reverse engineer Netezza Db tables ( Create PDM) and ultimately generate Oracle PDM and generate DDLs.

Some of the Datatypes like Varchar(n) and CHAR(n) are not converting properly during reverse eng

Varchar(n) is coming up as CHARACTER VARYING(n)

CHAR(n) is coming up as CHARACTER(n).

NVARCHAR(n) is coming up as NATIONAL CHARACTER VARYING(n).

We are using powerdesigner 16.6 and Netezza 7.x

Can anyone please advise?

[Former Member]

Thanks McGeachie for your response. I will change DataType conversion ( Target to internal, internal to Target) as per suggestion. I will update the progress if it helps in anyway.