If you've noticed some out-of-date Salesforce data in your data warehouse, we recommend checking to see if the field in question is a formula field.
Formula fields are algorithms that derive their value from other fields, expressions, or values. These fields can automatically calculate their value based on other fields.
A formula field that's calculated with another object's field might not cause the
LastModifiedDate field to change. Because Salesforce data is incrementally replicated based on
updated/modified_at, formula fields may not always be identified as having new values.
Opportunity.Custom_Field_Account_Name__c is an opportunity field that calculates the Account Name. If the Account Name changes, Salesforce will not indicate that the Opportunity formula field has changed, meaning the Opportunity record won't be detected by an incremental update.
If you're using it as a join, you could recreate the join using SQL.
If the field isn't a join, depending on what you need, you could still recreate it using SQL or change the field to be a native field that's updated through a workflow or apex trigger.