with the statement below I found that the IncrementalLoadStatuses@eol and IncrementalLoadStatuses@eol are not accurate. Is it possible ? for verification purpose I would like to check the status of the @eol cache. IncrementalLoadStatuses@eol give immediate results whereas the max() and count() on…

For up-to-date results it will be necessary to run for instance this query. This will - as a side-effect - update the contents of Incremental LoadStatuses@eol. A faster alternative can be for max(timestamp) to use: declare l_timestamp_max number; begin for r in ( select PartitionCode …

IncrementalLoadStatuses@eol and IncrementalLoadStatuses@eol not accurate?

Questions

forums 24 april 2024 om 13:57 7

Please see Analyzing missing rows on Exact Online REST APIs - 2 van forums for new analysis features.

Topic		Antwoorden	Weergaven
Synchronize inside a loop seems not working Questions exact-online , invantive-sql	4	148	21 maart 2024
Columns aliasing in PL/SQL Questions exact-online , invantive-sql	5	150	5 april 2024
Performance measurements large Exact Online companies with incremental (sync) APIs Wiki (en) exact-online , cloud	0	650	17 maart 2021
Analyzing missing rows on Invantive UniversalSQL-drivers Wiki (en) exact-online , kb-troubleshooting-article , invantive-data-replicator , invantive-cloud	1	754	24 april 2024
Cumulative Balances versus Budgets across Exact Online companies Wiki (en) exact-online , invantive-sql	1	723	2 november 2023

IncrementalLoadStatuses@eol and IncrementalLoadStatuses@eol not accurate?

Gerelateerde topics