Oracle CDC to JDBC loss of timestamp precision?

asked 2020-09-18 11:26:43 -0500

KateF gravatar image

updated 2020-09-18 11:28:26 -0500

Hi, I have a pipeline:

  • Oracle CDC Origin (reading from Oracle 18c db)
  • Expression Evaluator adds two fields
  • JDBC Destination (updating Oracle 18c db)

Data is flowing properly but the timestamp columns are losing precision:

image description

Is there something I can do to mitigate this or is it just a limitation?

Thanks, Kate

edit retag flag offensive close merge delete