Hi. I have replicated a PostgreSQL partitioned table in a MongoDB time series collection using debezium and Kafka. when I update a record in the PostgreSQL table I expect that the same record is updated in MongoDB collection but instead a new record is created.
according to the documentation if you set the timeseries.timefield option in the connector configs, the “InsertOneDefaultStrategy” write model will be applied which inserts each sink record into MongoDB as a document. Is there a way to change this behavior?
thanks for your time