30. a) Incremental load part 1

Hello Everyone,
Hope you guys are doing well. Stay safe.
This video will walk you through the incremental load in Qlik Sense.
This is part-1 of incremental Load.
Definition: Loading the new /updated records without loading the full data is called Incremental load.
Points to remember:
1. There are two QVDs
a) Full QVF: Which runs ones in gap so as to load the full data including the historical data as well.
b) Incremental QVF: Which Runs every regular intervals so as to merge the new/updated records
2. There is no key words used it is purely logic based
Why we do incremental Load: Suppose you have a Huge data which takes hours to load. We shouldn't be loading the full data , specially when there is minor or no change in historical data.
So, it is recommended to load the newer record in specific intervals.
Full Load can be done ones in a while depending upon the requirement.
In The Part-1 we are doing Insert-Update Incremental Load where new newer records gets uploaded in regular intervals and the change in the Historical data will be taken care by Full load (which Runs in a while).
Please find the code attached for better understanding.
Link for the Document:
Topic Briefs: drive.google.c...
Incremental Code: drive.google.c...
Note: (Document is for briefs, not for the detail description)
For more videos please visit: www.youtube.co....
Please follow me on:
LinkedIn: linkedin.com/in/biswadeep-moitra-98137079
Gmail: [e-mail]
Facebook: / biswadeep.moitra
Instagram: / biswadeep_moitra
Thank You

[@gyanaray7382]

All the videos posted by you are well explanatory and it really helps to make the fundamental clear in Qliksense. Many thanks for this.

[@nituverma3518]

Amazing video. But could you please make videos on QMC as well. How to get schedule the reports, how to make AD users and how to give access to users.

[@loke3969]

thanks for making videos and its help full for us

[@samkaran6351]

Cool, easy to understand

[@mukulrampal6255]

but , when you reload it is taking full load only with 7 records

[@manuelalejandroalvaradorub964]

Thanks for this, i'm working on a project similar to this

[@PS-vc6ef]

So you don't have to write concatenate?

[@NavyaSharma-s1l]

this is not insert and update case it only contains insert case

[@sathwik98]

This video is actually confusing. There is a lag between your voice and the screen recording. There is no sync

[@spotato]

Not well organized... a bit confusing

[@ssss8853]

confusing