Informix datatype mapping - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Informix Source Datatype

Snowflake Target Datatype

char varying(p)

Varchar(p)

char(p)

Varchar(p)

character

Varchar(1)

date

Date

DATETIME DAY TO SECOND

Timestamp_ntz(9)

DATETIME HOUR TO SECOND

Timestamp_ntz(8)

DATETIME MONTH TO DAY

Timestamp_ntz(5)

DATETIME MONTH TO SECOND

Timestamp_ntz(9)

DATETIME YEAR TO DAY

Timestamp_ntz(9)

DATETIME YEAR TO FRACTION

Timestamp_ntz(9)

DATETIME YEAR TO FRACTION (3)

Timestamp_ntz(9)

DATETIME YEAR TO FRACTION (5)

Timestamp_ntz(9)

DATETIME YEAR TO MINUTE

Timestamp_ntz(9)

DATETIME YEAR TO MONTH

Timestamp_ntz(7)

DATETIME YEAR TO SECOND

Timestamp_ntz(9)

decimal

Number(16,0)

decimal(p,s)

Number(p,s)

double precision

Float

float

Float

float (p)

Float

integer

Number(38,0)

INTERVAL DAY TO DAY

varchar(2)

INTERVAL DAY(9) TO FRACTION(5)

Varchar(24)

INTERVAL HOUR TO SECOND

Time(9)

INTERVAL YEAR(3) TO MONTH

varchar(6)

INTERVAL YEAR(9) TO MONTH

varchar(12)

money

Number(16,2)

money(p,s)

Number(p,s)

nchar

Varchar(1)

nchar(p)

Varchar(p)

numeric

Number(16,0)

numeric(p,s)

Number(p,s)

nvarchar

Varchar(1)

nvarchar(2)

Varchar(2)

real

Float

serial

Number(38,0)

smallfloat

Float

smallint

Number(38,0)

varchar

Varchar(1)

varchar(p)

Varchar(p)

The following table shows the Informix source datatypes that are available to map to a varchar target column in a table you create manually on the Snowflake target. If you create the varchar with no precision, by default the size will be 16777216. If you create a fixed-length varchar datatype, ensure this target definition is large enough to accommodate the data sent from the source column.

Informix Source Datatype

Snowflake Target Varchar

Date

varchar

Datetime

varchar

Decimal

varchar

Double

varchar

Float

varchar

Integer

varchar

Numeric

varchar

Real

varchar

SmallFloat

varchar

Smallint

varchar