Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
sonysree88
Creator II
Creator II

Exact differences between Incremental load and resident load with examples

Hi ,

Can you please elaborate exact differences between incremental load Vs resident load..

Thanks

Sony

1 Reply
swuehl
MVP
MVP

These two are totally different things.

A RESIDENT in your LOAD statement defines the source of the input table, i.e. it defines that the table should be loaded from your data model, using a table already loaded in your script in a LOAD statement before your current LOAD.

An incremental LOAD is a strategy to not load all data from the (DB) source, but only e.g. changed / inserted data and get the "old" data from a e.g. a QVD file.

See the examples in the reference manual, or search the forum for both expressions ("RESIDENT LOAD" vs. "INCREMENTAL LOAD"). You should find a lot of samples, e.g.

Re: Incremental Load with Example