Which one from the Database Diff Processor and Source Diff Processor is a more cost-effective write strategy?

In Database Diff Processor, records are either inserted or updated based on the audit field, whereas full comparison is made in Source Diff Processor. So, if you have a database table destination, Database Diff Processor would be used, and in case of an Excel or Delimited destination, Source Diff Processor would be the only option.