Qlik - 043: Incremental Load – Insert Only (with Practical Example of 60 Million records)

In this video we will see,
1) What is Incremental Load? (00:00:01 – 00:00:30)
2) Why we need Incremental Load? (00:00:31 – 00:01:20)
3) Basic steps of Incremental Load (00:01:21 – 00:01:45)
4) Types of Incremental Load (00:01:46 – 00:02:53)
5) Advantages of Incremental Load (00:02:54 – 00:03:20)
6) Flow Chart of Insert Only Incremental Load (00:03:21 – 00:06:28)
7) Introduction of data table used in this video (00:06:29 – 00:07:15)
8) First full load before Incremental Load (00:07:16 – 00:15:30)
9) Incremental Load with real time example (00:15:31 – 00:34:35)
10) Steps to consider while implementing Incremental Load (00:34:36 – 00:41:12)

If you want to read on Incremental Load from Qlik Help
https://help.qlik.com/en-US/sense/May...

Download material for this video from below link.
https://drive.google.com/drive/folder...

You can also find me on
YouTube:    / @manishkumarkachhia1683  
Facebook: https://www.facebook.com/profile.php?...
LinkedIn:   / manishkachhia  
Twitter:   / mk_qsl  
Udemy: https://www.udemy.com/user/manish-kac...

#qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #yearstart #yearend #pick #match #customisedreport #pivottable #networkdays #sql #sqlconnection #sqldataconnection #forloop #foreachloop #qvd #createqvd #aggregation #Total #MappingLoad #ApplyMap #MapUsing #NestedApplyMap #numberformat #incremental #incrementalload #deltaload #insertonlyincrementalload