Hi,
I am having table,
EMP Table
Emp details - values
empno - 1001,1002,1003
Ename - Ravi, Sreedevi, Prasad, Venkat
Sal - 123.4567 [Decimal]
JoiningDate - 2024-12-09T12:23:45 [Timestamp]
sending data from debezium cdc postgres connector to Oracle DB.
how to convert Decimal and timestamp values , is debezium will take SMT.
I have worked in jdbc using cast in Oracle.
for timestamp, I have used as below.
transforms= REQUIRED_DATE_CONVERTER
transforms.REQUIRED_DATE_CONVERTER.type= org.apache.kafka.connect.transforms.TimestampConverter$Value
transforms.REQUIRED_DATE_CONVERTER.format= yyyy-MM-dd
transforms.REQUIRED_DATE_CONVERTER.target.type= string
transforms.REQUIRED_DATE_CONVERTER.field= REQUIRED_DATE
how can we implement using debezium.