Exact differences between Incremental load and resident load with examples

sonysree88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

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

Thanks

Sony

Re: Exact differences between Incremental load and resident load with examples

swuehl — Tue, 19 Jul 2016 18:13:11 GMT

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

topic Exact differences between Incremental load and resident load with examples in QlikView

Exact differences between Incremental load and resident load with examples

Re: Exact differences between Incremental load and resident load with examples