PowerExchange for Kafka User Guide for PowerCenter

PowerExchange for Kafka User Guide for PowerCenter

JSON Kafka Data Types and Transformation Data Types

JSON Kafka Data Types and Transformation Data Types

JSON Kafka data types map to transformation data types that the PowerCenter Integration Service uses to move data across platforms.
The following table lists the JSON Kafka data types that the PowerCenter Integration Service supports and the corresponding transformation data types:
JSON Kafka Data Type
Transformation Data Type
Range and Description
BOOLEAN
Integer
TRUE (1) or FALSE (0)
DOUBLE
Double
Precision 15
INTEGER
Integer
-2,147,483,648 to 2,147,483,647
Precision of 10, scale of 0
LONG
Bigint
Precision of 19 digits, scale of 0
STRING
Nstring
1 to 104,857,600 characters

0 COMMENTS

We’d like to hear from you!