PowerExchange for Kafka User Guide for PowerCenter

PowerExchange for Kafka User Guide for PowerCenter

Kafka and Transformation Data Types

Kafka and Transformation Data Types

When the PowerCenter Integration Service reads source data, it converts the native data types to the comparable transformation data types before transforming the data. When the PowerCenter Integration Service writes to a target, it converts the transformation data types to the comparable native data types.
The following table lists the Kafka data types that PowerCenter supports and the corresponding transformation data types:
Kafka Data Type
Transformation Data Type
Range and Description
BINARY
Binary
1 to 104,857,600 bytes
INTEGER
Integer
Precision 10, scale 0
RAW
Binary
1 to 104,857,600 bytes
STRING
Nstring
1 to 104,857,600 characters
TIMESTAMP
Date/Time
Date and time values.
(precision to the nanosecond)

0 COMMENTS

We’d like to hear from you!