Hoping someone can point me in the right direction!
We have an integration stack/replication batch (Informatica) that copies all of our data from SFDC. The change data capture process is based off of SFDC's LastModifiedDate and SystemModStamp.
Our problem: Formula fields only generate their values at run-time/query-time, and in addition, do not change SFDC LastModifiedDate/SystemModStamp. In that case, our change data capture process does not know the record changed and will not pick it up in it's daily batch for refresh.
There are millions of records in the system, so a full refresh each day is not possible. Anyone know any workarounds with this or experience the same issue?
Regards, J Ramirez