You can translate the question and the replies:

Reconciliation Mechanism in Denodo

Hi Team, We have a use case wherein the Business expects the data to be reconciled on a weekly basis, if the reconciliation is successful, data between source and denodo matches then the data should be refreshed to the final view, if not then the final view should have the data till previous week. Can you help and suggest the innate denodo function which woould help us to acheive this. Thanks
user
25-02-2022 00:51:48 -0500
code

1 Answer

Hi, In general, the Denodo Platform will only store the metadata of the data sources and the data(results) from the underlying data sources are fetched in **realtime** i.e., the **exact data** available in the data source at a **given time** will be displayed in the Denodo Platform. If the data of the previous week needs to be displayed, then it is necessary to enable the [**cache**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/configuring_the_cache/configuring_the_cache#configuring-the-cache) for that [view](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/advanced_configuration_of_views/configuring_the_cache_of_a_view#configuring-the-cache-of-a-view) a week before and store the results(data) at that time in the cached database so that it is possible to retrieve them later. I would make use of the [Incremental cache](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/cache_module/cache_modes/incremental_mode) mode if the data alone varies with time in the underlying source. Else if the schema of the underlying source changes, then I would use the [Source Refresh](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/source_refresh/source_refresh) option available graphically or use the [**REFRESH** statement](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/refresh_views/refresh_views). Also, I would use the [**Scheduler**](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/index) of the Denodo Platform for automating these processes based on the requirements. Hope this helps!
Denodo Team
28-02-2022 00:37:03 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here