I am trying to sink multiple collections from one database to another and it is working fine for insert, update and delete operations.
However if in target database collection a record does not exist but it does exist in source database and an update operation is performed on it then I want sink connector to create a new record for the update operation. How can i achieve that?