JDBC multitable does not reflect the updated data(CDC) in the destination (JDBC producer).
I am using JDBC multitable consumer origin and JDBC producer destination .I tried Insert operation which gets data written in the destination table.But UPDATE and DELETE is not reflected in the destination but it is visible only in streamsets preview.Kindly help me to fix this.
Thank You
Are you seeing any errors in sdc.log?
No there were no errors. Streamsets shows running successfully,records fetched.But its not visible in the destination table.Only INSERT operation is reflected.Only visible in preview.
Even with JDBC Query Consumer I am facing the same problem.Only INSERT operation is reflected in the destination table,not UPDATE and DELETE.