Netezza to Azure SQL DW - Recommended Datatype Mapping

Netezza to Azure SQL DW datatype recommended mapping following successful DM Jumpstart POC:

Netezza

Azure SQL DW

NATIONAL CHARACTER VARYING

NVARCHAR

NATIONAL CHAR VARYING

NVARCHAR

NATIONAL CHARACTER

NCHAR

CHARACTER VARYING

VARCHAR

CHAR VARYING

VARCHAR

CHARACTER

CHAR

TIMESTAMP

DATETIME2

BOOLEAN

BIT

BYTEINT

TINYINT

INT1

TINYINT

INT2

SMALLINT

INT4

INTEGER

INT8

BIGINT

INTEGER

INT

FLOAT4

FLOAT(24)

FLOAT8

FLOAT(53)

DOUBLE PRECISION

FLOAT(53)

DOUBLE

FLOAT(53)

TIME WITH TIME ZONE

DATETIMEOFFSET

TIMETZ

DATETIMEOFFSET

TIME WITHOUT TIME ZONE

TIME

NUMERIC

NUMERIC

DECIMAL

DECIMAL

DATE

DATE

Netezza to Azure SQL DW function mapping indicative after successful DM Jumpstart POC:

Netezza Function

SQL DW Function

INT2(column)

CAST(COLUMN AS SMALLINT)

INT4(column)

CAST(COLUMN AS INT)

INT8(column)

CAST(COLUMN AS BIGINT)

HASH(column,0)

HASHBYTES('MD5', column)