Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

incremental load

What is mean by the incremental load .Could you pls Explain me Briefly

Thanks in Advance

Regards

Raviteja

3 Replies
luciancotea
Specialist
Specialist

Extract into QVD's only the changes from the db, not all the transactions.

You use a field that contains the timestamp of the last change. If you don't have one, you decide which transactions needs to be extracted. For example, there is no point in getting the previous years, you will always have the same transactions.

swuehl
MVP
MVP

In the reference manual, this is IMHO quite well explained. Search for chapter 'Using QVD files for incremental load'.

I think it's chapter 28.4

NavinReddy
Creator II
Creator II

1. Stored the previous load as a qvd

2. Load the previous qvd

3. Get max date from previous qvd

4. Load the new data (csv file) where date is greater than max date from previous loaded qvd file.