Data Integration Hub Connector Guide

Back Next

Data Integration Hub and Transformation Data Types

Informatica Cloud uses the JDBC type 4 driver to read data. The Secure Agent converts the

Data Integration Hub

data type to the transformation data type, and uses the transformation data type to move data across platforms.

When Informatica Cloud writes to a

Data Integration Hub

target, the Secure Agent converts the transformation data type to the corresponding

Data Integration Hub

data type. When Informatica Cloud reads from a

Data Integration Hub

source, the Secure Agent converts the

Data Integration Hub

data type to the corresponding transformation data type.

The following table compares the

Data Integration Hub

data types that Informatica Clouds supports to the transformation data types:

Data Integration Hub Data Type	Transformation Data Type	Range
BIGINT	Bigint	-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0
BINARY	Binary	1 to 104,857,600 bytes
BIT	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
BLOB	Binary	1 to 104,857,600 bytes
BOOLEAN	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
CHAR	String	1 to 104,857,600 characters
CLOB	Text	1 to 104,857,600 characters
DATE	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
DECIMAL	Decimal	Precision 1 to 28, scale 0 to 28
DOUBLE	Double	Precision 15
FLOAT	Double	Precision 15
INTEGER	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
LONGVARBINARY	Binary	1 to 104,857,600 bytes
LONGVARCHAR	Text	1 to 104,857,600 characters
NUMERIC	Decimal	Precision 1 to 28, scale 0 to 28
REAL	Double	Precision 15
SMALLINT	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
TIME	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
TIMESTAMP	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
TINYINT	Integer	-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
VARBINARY	Binary	1 to 104,857,600 bytes
VARCHAR	String	1 to 104,857,600 characters