Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Ruchika_Thakral
Partner - Contributor
Partner - Contributor

Increment Load Implementation without having incremental logic

My fact table lacks both a Modification Date & Time field and a Unique ID. How can I implement Incremental Load in this scenario?

Labels (1)
3 Replies
marcus_sommer

You may use a normal date-field and regarding the dates from today() - n as new and the elder ones as already existing and unchanged. It may not be perfect but will mostly serve the purpose - and it may only be the daily task and once a week/month in any idle hours a full-load is performed to fetch the neglected exceptions. 

morgankejerhag
Partner - Creator III
Partner - Creator III

If lines can be added and modified (and even removed) then you can't create that in the script. Look at Qlik Talend Cloud and CDC technology to stream changes.

Or
MVP
MVP

"My table lacks the requirements for incremental loading, how can I load incrementally?"

You can't, generally. You have to ask yourself (or your client) what logic can be used to recognize changes that need to be loaded, and how to recognize that the row in question needs to be changed, and if such a logic is available, that's your answer.