Recently we have had a few issue where our Datawarehouse team has claimed updated values in the tables however I am not seeing the same values in Adobe Campaign. Is there any kind of caching or setting that might cause these kinds of synchronization issues?
There is no explicit synchronization process which runs between the application and database server. Ideally whatever is updated at database level should be visible within the Application Server as well.
Which Schema is being checked here, as in which specific table is reflecting this discrepancy.