AnsweredAssumed Answered

Look for rows in SQL tables and views that have changed

Question asked by fgboom on Aug 10, 2017

Does Boomi have a way to know that any column in a SQL Table or View row has changed if the rows do not have a last modified date column? I am syncing SQL to Salesforce.com and I want to make sure I am updating rows that have changed and not only inserting new rows that have been created. Right now most of the tables/views I am working with do not have any kind of last modified date and I am trying to avoid adding that.

Outcomes