Load frequency, which is published for every table in the Data Dictionary, states how often the table is refreshed by the Clarity ETL. A frequency of INCREMENTAL indicates that the table is processed in the nightly extract and that only data changed since the previous run is brought across, rather than the full table being rebuilt. The practical effect is that the table is current as of the most recent nightly run, which is why Clarity reporting is described as reflecting the prior day ' s activity. The option claiming the table is not extracted is incorrect, because any table with a defined load frequency is part of the extract. A weekly cadence is a separate load frequency value and would be displayed as such. Nothing in the term refers to a monthly cap on rows; incremental describes the method of identifying changes and not a limit on volume. Understanding load frequency is operationally important. If a report needs same-day data, Clarity is not the correct source regardless of method. If a table appears to be missing recent changes, the analyst should confirm the frequency in the Data Dictionary and then review the extract status in the Clarity Console.
[Reference: Cogito Fundamentals – Clarity Data Model: Table Load Frequency; Data Dictionary, ===============, ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit