PowerExchange for Kafka User Guide for PowerCenter

PowerExchange for Kafka User Guide for PowerCenter

Avro Kafka Data Types and Transformation Data Types

Avro Kafka Data Types and Transformation Data Types

Avro Kafka data types map to transformation data types that the PowerCenter Integration Service uses to move data across platforms.
The following table lists the Avro Kafka and Avro Schema Registry data types that the PowerCenter Integration Service supports and the corresponding transformation data types:
Avro Kafka Data Type
Transformation Data Type
Range and Description
BOOLEAN
Integer
TRUE (1) or FALSE (0)
DOUBLE
Double
Precision 15
FLOAT
Double
Precision 15
INT
Integer
-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
LONG
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
STRING
NString
1 to 104,857,600 characters

0 COMMENTS

We’d like to hear from you!