Incremental Load

[dhavalvyas]

Hii,

I am doing incremental load for one of the application.

All the data are coming from SQl database.

I have 3 tables on which I want to apply incremental load. So hat i have to do.

Wheather first store in QVD and then apply where exist on it or before storing it in QVD apply where exist on it.

while i am applying where not exist before storing it in QVD that is while loading from SQL function where not exist want work ?

so i am confused in it. can anyone can help me.

[arvind_patil]

Hi Dhaval,

You Need to fetch only those records which are new. Then concatenate it with old Qvd and Then Store into qvd.

For reference : https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Thanks,

Arvind Patil

[its_anandrjs]

Hi,

First of all understand what is the process of the Incremental load basically it would be three types

1. Insertion Only

2. Insert, Delete Only

3. Insert, Delete and Update

Have on this threads

https://community.qlik.com/thread/84146‌

Regards

Anand