The product documentation warns about potential duplicate data after incremental updates using the append mode. For which use cases is the Append mode appropriate?
APPEND mode adds additional rows to a table. Once a row has been inserted, it is never updated or deleted. MERGE mode updates the existing records and inserts new records in the table that are captured via change data capture from the source systems.
Append-only tables are ideal for systems that don't update or delete records, such as security information events and management systems where data needs to be replicated from the events to a database.